﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="waybillsData" targetNamespace="http://tempuri.org/waybillsData.xsd" xmlns:mstns="http://tempuri.org/waybillsData.xsd" xmlns="http://tempuri.org/waybillsData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="NklQueries" GeneratorFunctionsComponentClassName="NklQueries" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="NklQueries" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MoronConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="MoronConnectionString (Settings)" PropertyReference="ApplicationSettings.DIProject.Properties.Settings.GlobalReference.Default.MoronConnectionString" Provider="System.Data.Odbc">
          </Connection>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DIAptekaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="DIAptekaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DIProject.Properties.Settings.GlobalReference.Default.DIAptekaConnectionString" Provider="System.Data.SqlClient">
          </Connection>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CiaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="CiaConnectionString (Settings)" PropertyReference="ApplicationSettings.DIProject.Properties.Settings.GlobalReference.Default.CiaConnectionString" Provider="System.Data.Odbc">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MoronTableAdapter" GeneratorDataComponentClassName="MoronTableAdapter" Name="Moron" UserDataComponentName="MoronTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MoronConnectionString (Settings)" DbObjectName="`D:\TEMP\MORON`.`00906697`" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `00906697` (`NUMNAK`, `DATAGOT`, `KODAPTEK`, `KODPOSTAV`, `KODNLKLEK`, `EAN13`, `CENARAS`, `CENARASDOL`, `CENAPRBNDS`, `CENAPROD`, `COUNT`, `SERIJ`, `SROKGOD`, `PRZPROD`, `NAMLEK`, `KODSTN`, `KODZAVOD`, `NAMSTRANA`, `NAMZAVOD`, `VID`, `KOLUP`, `PRCNDS`, `PRCNSP`, `OBAS`, `CENAREE`, `DATAREE`, `CENAREC`, `NUMDECLARE`, `NUMBER`, `SROK`, `NAMEPRINT`, `KODORG`, `PRZ_PRI`, `SUMBNDS`, `NDS10`, `NDS20`, `SUMNDS10`, `SUMNDS20`, `SUMNDS0`, `NACIMP`, `NACOPT`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NUMNAK" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NUMNAK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="DATAGOT" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATAGOT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODAPTEK" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODAPTEK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODPOSTAV" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODPOSTAV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODNLKLEK" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODNLKLEK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="EAN13" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EAN13" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENARAS" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENARAS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENARASDOL" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENARASDOL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENAPRBNDS" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENAPRBNDS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENAPROD" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENAPROD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="COUNT" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="COUNT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="SERIJ" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SERIJ" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="SROKGOD" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SROKGOD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="PRZPROD" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="PRZPROD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NAMLEK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAMLEK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODSTN" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODSTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODZAVOD" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODZAVOD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NAMSTRANA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAMSTRANA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NAMZAVOD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAMZAVOD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="VID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KOLUP" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KOLUP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="PRCNDS" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="PRCNDS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="PRCNSP" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="PRCNSP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="OBAS" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OBAS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENAREE" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENAREE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="DATAREE" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATAREE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="CENAREC" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="CENAREC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NUMDECLARE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUMDECLARE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NUMBER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUMBER" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="SROK" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SROK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="NAMEPRINT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAMEPRINT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="KODORG" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="KODORG" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="PRZ_PRI" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="PRZ_PRI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="SUMBNDS" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="SUMBNDS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NDS10" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NDS10" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NDS20" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NDS20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="SUMNDS10" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="SUMNDS10" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="SUMNDS20" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="SUMNDS20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="SUMNDS0" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="SUMNDS0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NACIMP" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NACIMP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NACOPT" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NACOPT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT NUMNAK, DATAGOT, KODAPTEK, KODPOSTAV, KODNLKLEK, EAN13, CENARAS, CENARASDOL, CENAPRBNDS, CENAPROD, `COUNT`, SERIJ, SROKGOD, PRZPROD, NAMLEK, KODSTN, KODZAVOD, NAMSTRANA, NAMZAVOD, VID, KOLUP, PRCNDS, PRCNSP, OBAS, CENAREE, DATAREE, CENAREC, NUMDECLARE, `NUMBER`, SROK, NAMEPRINT, KODORG, PRZ_PRI, SUMBNDS, NDS10, NDS20, SUMNDS10, SUMNDS20, SUMNDS0, NACIMP, NACOPT FROM `00906697`</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NUMNAK" DataSetColumn="NUMNAK" />
              <Mapping SourceColumn="DATAGOT" DataSetColumn="DATAGOT" />
              <Mapping SourceColumn="KODAPTEK" DataSetColumn="KODAPTEK" />
              <Mapping SourceColumn="KODPOSTAV" DataSetColumn="KODPOSTAV" />
              <Mapping SourceColumn="KODNLKLEK" DataSetColumn="KODNLKLEK" />
              <Mapping SourceColumn="EAN13" DataSetColumn="EAN13" />
              <Mapping SourceColumn="CENARAS" DataSetColumn="CENARAS" />
              <Mapping SourceColumn="CENARASDOL" DataSetColumn="CENARASDOL" />
              <Mapping SourceColumn="CENAPRBNDS" DataSetColumn="CENAPRBNDS" />
              <Mapping SourceColumn="CENAPROD" DataSetColumn="CENAPROD" />
              <Mapping SourceColumn="COUNT" DataSetColumn="COUNT" />
              <Mapping SourceColumn="SERIJ" DataSetColumn="SERIJ" />
              <Mapping SourceColumn="SROKGOD" DataSetColumn="SROKGOD" />
              <Mapping SourceColumn="PRZPROD" DataSetColumn="PRZPROD" />
              <Mapping SourceColumn="NAMLEK" DataSetColumn="NAMLEK" />
              <Mapping SourceColumn="KODSTN" DataSetColumn="KODSTN" />
              <Mapping SourceColumn="KODZAVOD" DataSetColumn="KODZAVOD" />
              <Mapping SourceColumn="NAMSTRANA" DataSetColumn="NAMSTRANA" />
              <Mapping SourceColumn="NAMZAVOD" DataSetColumn="NAMZAVOD" />
              <Mapping SourceColumn="VID" DataSetColumn="VID" />
              <Mapping SourceColumn="KOLUP" DataSetColumn="KOLUP" />
              <Mapping SourceColumn="PRCNDS" DataSetColumn="PRCNDS" />
              <Mapping SourceColumn="PRCNSP" DataSetColumn="PRCNSP" />
              <Mapping SourceColumn="OBAS" DataSetColumn="OBAS" />
              <Mapping SourceColumn="CENAREE" DataSetColumn="CENAREE" />
              <Mapping SourceColumn="DATAREE" DataSetColumn="DATAREE" />
              <Mapping SourceColumn="CENAREC" DataSetColumn="CENAREC" />
              <Mapping SourceColumn="NUMDECLARE" DataSetColumn="NUMDECLARE" />
              <Mapping SourceColumn="NUMBER" DataSetColumn="NUMBER" />
              <Mapping SourceColumn="SROK" DataSetColumn="SROK" />
              <Mapping SourceColumn="NAMEPRINT" DataSetColumn="NAMEPRINT" />
              <Mapping SourceColumn="KODORG" DataSetColumn="KODORG" />
              <Mapping SourceColumn="PRZ_PRI" DataSetColumn="PRZ_PRI" />
              <Mapping SourceColumn="SUMBNDS" DataSetColumn="SUMBNDS" />
              <Mapping SourceColumn="NDS10" DataSetColumn="NDS10" />
              <Mapping SourceColumn="NDS20" DataSetColumn="NDS20" />
              <Mapping SourceColumn="SUMNDS10" DataSetColumn="SUMNDS10" />
              <Mapping SourceColumn="SUMNDS20" DataSetColumn="SUMNDS20" />
              <Mapping SourceColumn="SUMNDS0" DataSetColumn="SUMNDS0" />
              <Mapping SourceColumn="NACIMP" DataSetColumn="NACIMP" />
              <Mapping SourceColumn="NACOPT" DataSetColumn="NACOPT" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierInvoiceDocInsertTableAdapter" GeneratorDataComponentClassName="SupplierInvoiceDocInsertTableAdapter" Name="SupplierInvoiceDocInsert" UserDataComponentName="SupplierInvoiceDocInsertTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.SupplierInvoiceDocInsert" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>dbo.SupplierInvoiceDocInsert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DocDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ContragentDocDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContragentDocNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PaymentDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="GId" DataSetColumn="GId" />
              <Mapping SourceColumn="DocTypeId" DataSetColumn="DocTypeId" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="ContragentId" DataSetColumn="ContragentId" />
              <Mapping SourceColumn="ContragentDocDate" DataSetColumn="ContragentDocDate" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
              <Mapping SourceColumn="PaymentDate" DataSetColumn="PaymentDate" />
              <Mapping SourceColumn="DepartmentUserId" DataSetColumn="DepartmentUserId" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierInvoiceLinesInsertTableAdapter" GeneratorDataComponentClassName="SupplierInvoiceLinesInsertTableAdapter" Name="SupplierInvoiceLinesInsert" UserDataComponentName="SupplierInvoiceLinesInsertTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="ClientOne.dbo.SupplierInvoiceLinesInsert" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>SupplierInvoiceLinesInsert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BarCode" Precision="0" ProviderType="Char" Scale="0" Size="12" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocQntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierGoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ManufacturerPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SupplierPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SupplierSumNOTAX" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ImportMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SupplierMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BatchNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ReadyBefore" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MadeDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@NDSTax" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NDSValue" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ReestrPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ReestrDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GTDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CertificateNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="80" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CertificateDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CertificateOrgId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RetailMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="DocQntty" DataSetColumn="DocQntty" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="RetailSum" DataSetColumn="RetailSum" />
              <Mapping SourceColumn="SupplierGoodsId" DataSetColumn="SupplierGoodsId" />
              <Mapping SourceColumn="ManufacturerPrice" DataSetColumn="ManufacturerPrice" />
              <Mapping SourceColumn="SupplierPrice" DataSetColumn="SupplierPrice" />
              <Mapping SourceColumn="ImportMarkup" DataSetColumn="ImportMarkup" />
              <Mapping SourceColumn="SupplierMarkup" DataSetColumn="SupplierMarkup" />
              <Mapping SourceColumn="BatchNumber" DataSetColumn="BatchNumber" />
              <Mapping SourceColumn="ReadyBefore" DataSetColumn="ReadyBefore" />
              <Mapping SourceColumn="MadeDate" DataSetColumn="MadeDate" />
              <Mapping SourceColumn="NDSTax" DataSetColumn="NDSTax" />
              <Mapping SourceColumn="NDSValue" DataSetColumn="NDSValue" />
              <Mapping SourceColumn="ReestrPrice" DataSetColumn="ReestrPrice" />
              <Mapping SourceColumn="ReestrDate" DataSetColumn="ReestrDate" />
              <Mapping SourceColumn="GTDNumber" DataSetColumn="GTDNumber" />
              <Mapping SourceColumn="CertificateNumber" DataSetColumn="CertificateNumber" />
              <Mapping SourceColumn="CertificateDate" DataSetColumn="CertificateDate" />
              <Mapping SourceColumn="CertificateOrgId" DataSetColumn="CertificateOrgId" />
              <Mapping SourceColumn="RetailMarkup" DataSetColumn="RetailMarkup" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="SupplierSumNOTAX" DataSetColumn="SupplierSumNOTAX" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocumentsTableAdapter" GeneratorDataComponentClassName="DocumentsTableAdapter" Name="Documents" UserDataComponentName="DocumentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>IF (@ContragentId &lt;&gt; - 100) BEGIN SELECT     CA.Documents.Id, CA.Documents.DocDate, CA.Documents.DocNumber, CA.Documents.ContragentDocDate, 
                                                                                                  CA.Documents.ContragentDocNumber + ' (' + CONVERT(varchar, CA.Documents.ContragentDocDate, 104) 
                                                                                                  + ')' + '(' + ISNULL(CA.Documents.Note, 'нд') AS ContragentDocNumber, CAST(DocNumber AS int) AS ord, 
                                                                                                  CA.Documents.MD
                                                                           FROM          CA.Documents
                                                                           WHERE      DocTypeId IN (2, 5, 7, 6) AND (ContragentId = @ContragentId) AND DepartmentId = @DepartmentId
                                                                           ORDER BY 2 DESC END ELSE BEGIN
                                                                                                      SELECT     CA.Documents.Id, DocDate, DocNumber, ContragentDocDate, 
                                                                                                                              ContragentDocNumber + ' (' + CONVERT(varchar, ContragentDocDate, 104) 
                                                                                                                              + ')' + '(' + ISNULL(CA.Documents.Note, 'нд') + ')' + '(' + c.ShortName + ')' AS ContragentDocNumber, 
                                                                                                                              CAST(DocNumber AS int) AS ord, CA.Documents.MD
                                                                                                       FROM         CA.Documents INNER JOIN
                                                                                                                              CA.Contragents AS c ON CA.Documents.ContragentId = c.Id
                                                                                                       WHERE     DocTypeId IN (2, 5, 7, 6) AND DepartmentId = @DepartmentId
                                                                                                       ORDER BY 2 DESC END</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="ContragentDocDate" DataSetColumn="ContragentDocDate" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
              <Mapping SourceColumn="ord" DataSetColumn="ord" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CurrentNaklTableAdapter" GeneratorDataComponentClassName="CurrentNaklTableAdapter" Name="CurrentNakl" UserDataComponentName="CurrentNaklTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     il.Id, il.GoodsId, il.ManufacturerPrice, il.SupplierPrice, il.NDSValue, il.NDSTax, il.RetailMarkup, il.ReadyBefore, il.MadeDate, il.ReestrPrice, il.ReestrDate, il.DocQntty, 
                      il.DocId, gd.FullName, gd.ManufacturerName, gd.CountryName, il.DocQntty AS Count, a.GNVLS, il.MW, il.MD, il.Note, il.ContragentDocNumber, il.ContragentDocDate, 
                      il.ContragentId, il.CertificateOrgId, il.CertificateDate, il.CertificateNumber, il.BatchNumber, il.GTDNumber, il.SupplierMarkup, il.ImportMarkup, il.SupplierGoodsId, 
                      vil.BarCode, vil.RetailPrice, vil.Qntty, il.SupplierSumNOTAX, plp.Price AS SamsonPrice
FROM         CD.InputLines AS il INNER JOIN
                      CA.Goods AS g ON il.GoodsId = g.Id INNER JOIN
                      CA.Assortment AS a ON g.AssortmentId = a.Id INNER JOIN
                      vwInputLines AS vil ON il.Id = vil.Id LEFT OUTER JOIN
                      vwGoodsDetailed AS gd ON il.GoodsId = gd.Id LEFT OUTER JOIN
                          (SELECT     GoodsId, MAX(Price) AS Price
                            FROM          PR.PriceLinesParsed
                            WHERE      (ContragentId = 2036265)
                            GROUP BY GoodsId) AS plp ON plp.GoodsId = g.Id
WHERE     (il.DocId = @docId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="docId" ColumnName="DocId" DataSourceName="DIApteka.CD.InputLines" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@docId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="ManufacturerPrice" DataSetColumn="ManufacturerPrice" />
              <Mapping SourceColumn="SupplierPrice" DataSetColumn="SupplierPrice" />
              <Mapping SourceColumn="NDSValue" DataSetColumn="NDSValue" />
              <Mapping SourceColumn="NDSTax" DataSetColumn="NDSTax" />
              <Mapping SourceColumn="ReadyBefore" DataSetColumn="ReadyBefore" />
              <Mapping SourceColumn="MadeDate" DataSetColumn="MadeDate" />
              <Mapping SourceColumn="ReestrPrice" DataSetColumn="ReestrPrice" />
              <Mapping SourceColumn="ReestrDate" DataSetColumn="ReestrDate" />
              <Mapping SourceColumn="DocQntty" DataSetColumn="DocQntty" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
              <Mapping SourceColumn="GNVLS" DataSetColumn="GNVLS" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
              <Mapping SourceColumn="ContragentDocDate" DataSetColumn="ContragentDocDate" />
              <Mapping SourceColumn="ContragentId" DataSetColumn="ContragentId" />
              <Mapping SourceColumn="CertificateOrgId" DataSetColumn="CertificateOrgId" />
              <Mapping SourceColumn="CertificateDate" DataSetColumn="CertificateDate" />
              <Mapping SourceColumn="CertificateNumber" DataSetColumn="CertificateNumber" />
              <Mapping SourceColumn="BatchNumber" DataSetColumn="BatchNumber" />
              <Mapping SourceColumn="GTDNumber" DataSetColumn="GTDNumber" />
              <Mapping SourceColumn="SupplierMarkup" DataSetColumn="SupplierMarkup" />
              <Mapping SourceColumn="ImportMarkup" DataSetColumn="ImportMarkup" />
              <Mapping SourceColumn="SupplierGoodsId" DataSetColumn="SupplierGoodsId" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="SupplierSumNOTAX" DataSetColumn="SupplierSumNOTAX" />
              <Mapping SourceColumn="RetailMarkup" DataSetColumn="RetailMarkup" />
              <Mapping SourceColumn="SamsonPrice" DataSetColumn="SamsonPrice" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PartiesUpdateTableAdapter" GeneratorDataComponentClassName="PartiesUpdateTableAdapter" Name="PartiesUpdate" UserDataComponentName="PartiesUpdateTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.PartiesUpdate" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>dbo.PartiesUpdate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BarCode" Precision="0" ProviderType="Char" Scale="0" Size="12" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Blocked" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RestQntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="InputLineId" DataSetColumn="InputLineId" />
              <Mapping SourceColumn="Blocked" DataSetColumn="Blocked" />
              <Mapping SourceColumn="RestQntty" DataSetColumn="RestQntty" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierInvoiceLinesUpdateTableAdapter" GeneratorDataComponentClassName="SupplierInvoiceLinesUpdateTableAdapter" Name="SupplierInvoiceLinesUpdate" UserDataComponentName="SupplierInvoiceLinesUpdateTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="ClientOne.dbo.SupplierInvoiceLinesUpdate" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
                    <CommandText>SupplierInvoiceLinesUpdate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="GoodsId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BarCode" Precision="0" ProviderType="Char" Scale="0" Size="12" SourceColumn="BarCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocQntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocQntty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Qntty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierGoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="SupplierGoodsId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ManufacturerPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="ManufacturerPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SupplierPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="SupplierPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SupplierSumNOTAX" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="SupplierSumNOTAX" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ImportMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumn="ImportMarkup" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SupplierMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumn="SupplierMarkup" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BatchNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="BatchNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ReadyBefore" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ReadyBefore" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MadeDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="MadeDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@NDSTax" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="NDSTax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NDSValue" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="NDSValue" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ReestrPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="ReestrPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ReestrDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ReestrDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GTDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="GTDNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CertificateNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="80" SourceColumn="CertificateNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CertificateDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="CertificateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CertificateOrgId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="CertificateOrgId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RetailMarkup" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumn="RetailMarkup" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="RetailPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="DocQntty" DataSetColumn="DocQntty" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="RetailSum" DataSetColumn="RetailSum" />
              <Mapping SourceColumn="SupplierGoodsId" DataSetColumn="SupplierGoodsId" />
              <Mapping SourceColumn="ManufacturerPrice" DataSetColumn="ManufacturerPrice" />
              <Mapping SourceColumn="SupplierPrice" DataSetColumn="SupplierPrice" />
              <Mapping SourceColumn="ImportMarkup" DataSetColumn="ImportMarkup" />
              <Mapping SourceColumn="SupplierMarkup" DataSetColumn="SupplierMarkup" />
              <Mapping SourceColumn="BatchNumber" DataSetColumn="BatchNumber" />
              <Mapping SourceColumn="ReadyBefore" DataSetColumn="ReadyBefore" />
              <Mapping SourceColumn="MadeDate" DataSetColumn="MadeDate" />
              <Mapping SourceColumn="NDSTax" DataSetColumn="NDSTax" />
              <Mapping SourceColumn="NDSValue" DataSetColumn="NDSValue" />
              <Mapping SourceColumn="ReestrPrice" DataSetColumn="ReestrPrice" />
              <Mapping SourceColumn="ReestrDate" DataSetColumn="ReestrDate" />
              <Mapping SourceColumn="GTDNumber" DataSetColumn="GTDNumber" />
              <Mapping SourceColumn="CertificateNumber" DataSetColumn="CertificateNumber" />
              <Mapping SourceColumn="CertificateDate" DataSetColumn="CertificateDate" />
              <Mapping SourceColumn="CertificateOrgId" DataSetColumn="CertificateOrgId" />
              <Mapping SourceColumn="RetailMarkup" DataSetColumn="RetailMarkup" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="PartyId" DataSetColumn="PartyId" />
              <Mapping SourceColumn="SupplierSumNOTAX" DataSetColumn="SupplierSumNOTAX" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SZDataTableAdapter" GeneratorDataComponentClassName="SZDataTableAdapter" Name="SZData" UserDataComponentName="SZDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT        d.Id, d.DocNumber, pp.pid, CAST(ISNULL(d.ContragentDocNumber, d.Id) AS varchar(20)) 
                         + CASE WHEN d .DocTypeId = 10 THEN ' переоценка ' ELSE '' END + CAST(d.DocDate AS varchar(20)) AS ContragentDocNumber
FROM            CA.Documents AS d INNER JOIN
                             (SELECT        COUNT(Id) AS pid, DocId
                               FROM            CD.Parties AS p
                               GROUP BY DocId) AS pp ON pp.DocId = d.Id AND pp.pid &gt; 0 AND d.DocTypeId IN (2, 5, 6, 10, 12)
WHERE        (d.ContragentId = @ContragentId)
ORDER BY d.DocDate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="ContragentId" ColumnName="ContragentId" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContragentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="pid" DataSetColumn="pid" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SZDataDetailTableAdapter" GeneratorDataComponentClassName="SZDataDetailTableAdapter" Name="SZDataDetail" UserDataComponentName="SZDataDetailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT        vwGoodsDetailed.FullName, CD.Parties.BarCode, CD.Parties.RetailPrice, 
                         CASE WHEN CD.Parties.RestQntty = 0 THEN dbo.vwInputLines.Qntty ELSE CD.Parties.RestQntty END AS RestQntty, CA.Documents.Id AS DocId, 
                         CD.Parties.Id AS PartyId
FROM            CD.Parties INNER JOIN
                         CA.Documents ON CD.Parties.DocId = CA.Documents.Id INNER JOIN
                         vwGoodsDetailed ON CD.Parties.GoodsId = vwGoodsDetailed.Id LEFT OUTER JOIN
                         vwInputLines ON CD.Parties.Id = vwInputLines.PartyId
WHERE        (CA.Documents.Id = @DocId) AND (CA.Documents.DocTypeId IN (2, 5, 6, 10, 12))
ORDER BY vwGoodsDetailed.FullName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="Id" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="RestQntty" DataSetColumn="RestQntty" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="PartyId" DataSetColumn="PartyId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContragentsLinksTableAdapter" GeneratorDataComponentClassName="ContragentsLinksTableAdapter" Name="ContragentsLinks" UserDataComponentName="ContragentsLinksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     CA.GoodsVsContragents.GoodsName AS ContragentGoodName, vwGoodsDetailed.FullName AS InnerGoodName, 
                      vwGoodsDetailed.ManufacturerName AS InnerManufacturerName, vwGoodsDetailed.CountryName AS InnerCountryName, 
                      CA.GoodsVsContragents.CountryName AS ContragentCountryName, CA.GoodsVsContragents.ManufacturerName AS ContragentManufacturerName, 
                      CA.GoodsVsContragents.GoodsId, CA.GoodsVsContragents.Id
FROM         CA.GoodsVsContragents INNER JOIN
                      vwGoodsDetailed ON CA.GoodsVsContragents.GoodsId = vwGoodsDetailed.Id
WHERE     (CA.GoodsVsContragents.ContragentId = @ContragentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ContragentId" ColumnName="ContragentId" DataSourceName="DIApteka.CA.GoodsVsContragents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContragentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContragentGoodName" DataSetColumn="ContragentGoodName" />
              <Mapping SourceColumn="InnerGoodName" DataSetColumn="InnerGoodName" />
              <Mapping SourceColumn="InnerManufacturerName" DataSetColumn="InnerManufacturerName" />
              <Mapping SourceColumn="InnerCountryName" DataSetColumn="InnerCountryName" />
              <Mapping SourceColumn="ContragentCountryName" DataSetColumn="ContragentCountryName" />
              <Mapping SourceColumn="ContragentManufacturerName" DataSetColumn="ContragentManufacturerName" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierReturnsTableAdapter" GeneratorDataComponentClassName="SupplierReturnsTableAdapter" Name="SupplierReturns" UserDataComponentName="SupplierReturnsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
                    <CommandText>SupplierReturnDocDelete</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
                    <CommandText>SupplierReturnDocInsert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="InputOutput" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DocDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DocDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="InputOutput" ParameterName="@DocNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="DocNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="SupplierId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="InputOutput" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>select	Id					= d.Id
	,	DocDate				= d.DocDate
	,	DocNumber			= d.DocNumber
	,	SupplierId			= c.Id
	,	SupplierName		= c.ShortName
	,	Lines				= count(l.Id)
	,	DocSum				= coalesce(sum(-l.RetailSum), 0)
	,	Note				= d.Note
	,	MD					= d.MD
	,	MW					= d.MW
from	ca.Documents		d
join	ca.Contragents		c
	on	c.Id				= d.ContragentId
left join ca.GoodsDocLines	l
	on	l.DocId				= d.Id
where	d.DocTypeId			= 8
group by d.Id, d.DocDate, d.DocNumber, c.Id, c.ShortName, d.Note, d.MD, d.MW
order by d.DocDate, d.DocNumber
</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
                    <CommandText>SupplierReturnDocUpdate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DocDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DocDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="DocNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="SupplierId" DataSetColumn="SupplierId" />
              <Mapping SourceColumn="SupplierName" DataSetColumn="SupplierName" />
              <Mapping SourceColumn="Lines" DataSetColumn="Lines" />
              <Mapping SourceColumn="DocSum" DataSetColumn="DocSum" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SetificatedOrgTableAdapter" GeneratorDataComponentClassName="SetificatedOrgTableAdapter" Name="SetificatedOrg" UserDataComponentName="SetificatedOrgTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CA.Contragents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Id, Name
FROM         CA.Contragents
WHERE     (IsSertification = 1)
ORDER BY Name</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierReturnLinesTableAdapter" GeneratorDataComponentClassName="SupplierReturnLinesTableAdapter" Name="SupplierReturnLines" UserDataComponentName="SupplierReturnLinesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>SupplierReturnLinesDelete</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>SupplierReturnLinesInsert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PartyId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="PartyId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Qntty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailSum" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="RetailSum" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>select	Id					= l.Id
	,	DocId				= l.DocId
	,	PartyId				= l.PartyId
	,	SupplierDocId		= r.DocId
	,	Name				= v.FullName
	,	ManufacturerId		= g.ManufacturerId
	,	ManufacturerName	= v.ManufacturerName
	,	RetailPrice			= p.RetailPrice
	,	Qntty				= -l.Qntty
	,	RetailSum			= -l.RetailSum
	,	ReturnLineId		= l.ReturnLineId
	,	Note				= l.Note
	,	MD					= l.MD
	,	MW					= l.MW
from	ca.Documents		d
join	ca.GoodsDocLines	l
	on	l.DocId				= d.Id
join	ca.GoodsDocLines	r
	on	r.Id				= l.ReturnLineId
join	cd.Parties			p
	on	p.Id				= l.PartyId
join	ca.Goods			g
	on	g.Id				= p.GoodsId
join	dbo.vwGoodsDetailed	v
	on	v.Id				= p.GoodsId
where	d.Id				= @DocId
	and	d.DocTypeId			= 8
order by v.FullName, v.ManufacturerName
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="Id" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>SupplierReturnLinesUpdate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PartyId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="PartyId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qntty" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Qntty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailSum" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="RetailSum" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="PartyId" DataSetColumn="PartyId" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="RetailSum" DataSetColumn="RetailSum" />
              <Mapping SourceColumn="ReturnLineId" DataSetColumn="ReturnLineId" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="ManufacturerId" DataSetColumn="ManufacturerId" />
              <Mapping SourceColumn="SupplierDocId" DataSetColumn="SupplierDocId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vwGoodsDetailedTableAdapter" GeneratorDataComponentClassName="vwGoodsDetailedTableAdapter" Name="vwGoodsDetailed" UserDataComponentName="vwGoodsDetailedTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIOffice.dbo.vwGoodsDetailed" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     FullName, Id, ManufacturerName, CountryName
FROM         vwGoodsDetailed
WHERE     (ToDelete = 0)
ORDER BY FullName</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GoodsVsContragentsInsertTableAdapter" GeneratorDataComponentClassName="GoodsVsContragentsInsertTableAdapter" Name="GoodsVsContragentsInsert" UserDataComponentName="GoodsVsContragentsInsertTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.GoodsVsContragentsInsertEx" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>GoodsVsContragentsInsertEx</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GoodsCode" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GoodsName" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ManufacturerName" Precision="0" ProviderType="VarChar" Scale="0" Size="70" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="GId" DataSetColumn="GId" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="ContragentId" DataSetColumn="ContragentId" />
              <Mapping SourceColumn="GoodsCode" DataSetColumn="GoodsCode" />
              <Mapping SourceColumn="GoodsName" DataSetColumn="GoodsName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
                    <CommandText>OrderDocDelete</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     t.Id AS t_Id, d.Id, t.DocDate, t.DocNumber, c.Id AS SupplierId, c.ShortName AS SupplierName, d.DocDate AS SupplierDocDate, 
                      d.DocNumber AS SupplierDocNumber, COUNT(l.Id) AS Lines, COALESCE (SUM(l.QnttySum), 0) AS DocSum, t.Note, t.MD AS t_MD, t.MW AS t_MW, d.MD, 
                      d.MW
FROM         CA.Documents AS t INNER JOIN
                      CA.Documents AS d ON d.DocTypeId = 11 AND d.ParentId = t.Id INNER JOIN
                      CA.Contragents AS c ON c.Id = d.ContragentId LEFT OUTER JOIN
                      CD.ManageDocLines AS l ON l.DocId = d.Id
WHERE     (t.DocTypeId = 13)
GROUP BY t.Id, d.Id, t.DocDate, t.DocNumber, c.Id, c.ShortName, d.DocDate, d.DocNumber, t.Note, t.MD, t.MW, d.MD, d.MW
ORDER BY t.DocDate, t.DocNumber, SupplierName</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="SupplierId" DataSetColumn="SupplierId" />
              <Mapping SourceColumn="SupplierName" DataSetColumn="SupplierName" />
              <Mapping SourceColumn="SupplierDocDate" DataSetColumn="SupplierDocDate" />
              <Mapping SourceColumn="SupplierDocNumber" DataSetColumn="SupplierDocNumber" />
              <Mapping SourceColumn="Lines" DataSetColumn="Lines" />
              <Mapping SourceColumn="DocSum" DataSetColumn="DocSum" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="t_MD" DataSetColumn="t_MD" />
              <Mapping SourceColumn="t_MW" DataSetColumn="t_MW" />
              <Mapping SourceColumn="t_Id" DataSetColumn="t_Id" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderMTableAdapter" GeneratorDataComponentClassName="OrderMTableAdapter" Name="OrderM" UserDataComponentName="OrderMTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>select	Id					= g.Id
	,	DocId				= d.Id
	,	FullName			= g.FullName
	,	ManufacturerName	= g.ManufacturerName
	,	CountryName			= g.CountryName
	,	RetailPack			= g.RetailPack
	,	RestQntty			= sum(p.RestQntty)
	,	OrderQntty			= l.Qntty
	,	OrderSum			= l.QnttySum
from	vwGoodsDetailed		g
join	cd.Parties			p
	on	p.GoodsId			= g.id
left join ca.Documents		d
	on	d.DocTypeId			= 11
	and	d.ParentId			= @DocId
left join cd.ManageDocLines	l
	on	l.DocId				= d.Id
	and	l.GoodsId			= g.Id
group by g.Id, d.Id, g.FullName, g.ManufacturerName, g.CountryName, g.RetailPack, l.Qntty, l.QnttySum
order by g.FullName, g.ManufacturerName
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="RetailPack" DataSetColumn="RetailPack" />
              <Mapping SourceColumn="RestQntty" DataSetColumn="RestQntty" />
              <Mapping SourceColumn="OrderQntty" DataSetColumn="OrderQntty" />
              <Mapping SourceColumn="OrderSum" DataSetColumn="OrderSum" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderSTableAdapter" GeneratorDataComponentClassName="OrderSTableAdapter" Name="OrderS" UserDataComponentName="OrderSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>select	DocId					= d.Id
	,	GoodsId					= p.GoodsId
	,	SupplierId				= m.ContragentId
	,	SupplierName			= c.ShortName
	,	BatchNumber				= p.BatchNumber
	,	ReadyBefore				= p.ReadyBefore
	,	ReestrPrice				= p.ReestrPrice
	,	ReestrDate				= p.ReestrDate
	,	NDSTax					= p.NDSTax
	,	Price					= p.Price
	,	Qntty					= p.Qntty
	,	OrderQntty				= l.Qntty
	,	OrderSum				= l.QnttySum
from	pr.PriceLinesParsed		p
join	ca.GoodsVsContragents	m
	on	m.Id					= p.GoodsVsContragentsId
join	ca.Contragents			c
	on	c.Id					= m.ContragentId
left join ca.Documents			d
	on	d.DocTypeId				= 11
	and	d.ParentId				= @DocId
left join cd.ManageDocLines		l
	on	l.DocId					= d.Id
	and	l.GoodsId				= p.GoodsId
order by p.GoodsId, p.Price
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
              <Mapping SourceColumn="SupplierId" DataSetColumn="SupplierId" />
              <Mapping SourceColumn="SupplierName" DataSetColumn="SupplierName" />
              <Mapping SourceColumn="BatchNumber" DataSetColumn="BatchNumber" />
              <Mapping SourceColumn="ReadyBefore" DataSetColumn="ReadyBefore" />
              <Mapping SourceColumn="ReestrPrice" DataSetColumn="ReestrPrice" />
              <Mapping SourceColumn="ReestrDate" DataSetColumn="ReestrDate" />
              <Mapping SourceColumn="NDSTax" DataSetColumn="NDSTax" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="OrderQntty" DataSetColumn="OrderQntty" />
              <Mapping SourceColumn="OrderSum" DataSetColumn="OrderSum" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PartiesTableAdapter" GeneratorDataComponentClassName="PartiesTableAdapter" Name="Parties" UserDataComponentName="PartiesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     CD.Parties.RestQntty, vwGoodsDetailed.FullName, vwGoodsDetailed.ManufacturerName, vwGoodsDetailed.CountryName, CD.Parties.RetailPrice, 
                      CD.Parties.Blocked, CD.Parties.BarCode, CD.Parties.MD AS OriginalMD, CD.Parties.MW, CD.Parties.Id AS Original_id, CD.Parties.Note, 
                      CA.Documents.DocDate, CD.Parties.MD, CD.Parties.GoodsId
FROM         CD.Parties INNER JOIN
                      vwGoodsDetailed ON CD.Parties.GoodsId = vwGoodsDetailed.Id INNER JOIN
                      CA.Documents ON CD.Parties.DocId = CA.Documents.Id
WHERE     (CD.Parties.DocId = @DocId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="DocId" DataSourceName="DIOffice.CD.Parties" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>PartiesUpdate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetailPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="RetailPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BarCode" Precision="0" ProviderType="Char" Scale="0" Size="12" SourceColumn="BarCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Blocked" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Blocked" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="MD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Original_id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="OriginalMD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RestQntty" DataSetColumn="RestQntty" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Blocked" DataSetColumn="Blocked" />
              <Mapping SourceColumn="BarCode" DataSetColumn="BarCode" />
              <Mapping SourceColumn="OriginalMD" DataSetColumn="OriginalMD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="Original_id" DataSetColumn="Original_id" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="GoodsId" DataSetColumn="GoodsId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocNoPartyTableAdapter" GeneratorDataComponentClassName="DocNoPartyTableAdapter" Name="DocNoParty" UserDataComponentName="DocNoPartyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIOffice.CA.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     D.DocNumber, D.DocDate
FROM         CD.Parties AS P RIGHT OUTER JOIN
                      CA.Documents AS D ON P.DocId = D.Id
WHERE     (D.DocTypeId IN (2, 5, 6, 10, 12)) AND (P.Id IS NULL) AND (D.ContragentId = @ContragentId)
ORDER BY D.DocDate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="ContragentId" ColumnName="ContragentId" DataSourceName="DIOffice.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContragentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocWithPartyTableAdapter" GeneratorDataComponentClassName="DocWithPartyTableAdapter" Name="DocWithParty" UserDataComponentName="DocWithPartyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka1.CA.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT DISTINCT SUM(CONVERT(int, P.Blocked)) AS Nblocked, D.ContragentDocNumber AS DocNumber, D.ContragentDocDate AS DocDate, D.Id
FROM         CD.Parties AS P INNER JOIN
                      CA.Documents AS D ON P.DocId = D.Id
WHERE     (D.DocTypeId IN (2, 5, 6, 10, 12)) AND (D.ContragentId = @ContragentId) AND (P.RestQntty &gt; 0)
GROUP BY P.Blocked, D.ContragentDocNumber, D.ContragentDocDate, D.Id
ORDER BY DocDate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="ContragentId" ColumnName="ContragentId" DataSourceName="DIApteka1.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContragentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContragentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Nblocked" DataSetColumn="Nblocked" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ManufacturerAndCountryTableAdapter" GeneratorDataComponentClassName="ManufacturerAndCountryTableAdapter" Name="ManufacturerAndCountry" UserDataComponentName="ManufacturerAndCountryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.vwGoodsDetailed" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ManufacturerName, CountryName
FROM         vwGoodsDetailed
WHERE     (Id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="Id" DataSourceName="DIApteka.dbo.vwGoodsDetailed" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NKLDInfoTableAdapter" GeneratorDataComponentClassName="NKLDInfoTableAdapter" Name="NKLDInfo" UserDataComponentName="NKLDInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CA.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ContragentDocDate, ContragentDocNumber, DocDate, DocNumber
FROM         CA.Documents
WHERE     (Id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="Id" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContragentDocDate" DataSetColumn="ContragentDocDate" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierReturnPartiesTableAdapter" GeneratorDataComponentClassName="SupplierReturnPartiesTableAdapter" Name="SupplierReturnParties" UserDataComponentName="SupplierReturnPartiesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     p.Id, d.DocDate, d.DocNumber, d.ContragentDocDate, d.ContragentDocNumber, g.FullName AS Name, CA.Goods.ManufacturerId, g.ManufacturerName, 
                      g.CountryName, i.SupplierPrice AS RetailPrice, p.RestQntty AS Qntty, p.BarCode AS Barcode, p.Note, CAST(0 AS bit) AS Expiration, 
                      i.DocId AS SupplierDocId, CA.Goods.AllowUnPack, CA.Goods.RetailPack, p.MD, p.MW
FROM         CA.Documents AS d INNER JOIN
                      CD.InputLines AS i ON d.Id = i.DocId INNER JOIN
                      CD.Parties AS p ON i.Id = p.InputLineId INNER JOIN
                      vwGoodsDetailed AS g ON p.GoodsId = g.Id INNER JOIN
                      CA.Goods ON p.GoodsId = CA.Goods.Id
WHERE     (p.RestQntty &gt; 0) AND (d.ContragentId = @SupplierId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="SupplierId" ColumnName="ContragentId" DataSourceName="DIApteka.CA.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SupplierId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContragentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="DocDate" DataSetColumn="DocDate" />
              <Mapping SourceColumn="DocNumber" DataSetColumn="DocNumber" />
              <Mapping SourceColumn="ContragentDocDate" DataSetColumn="ContragentDocDate" />
              <Mapping SourceColumn="ContragentDocNumber" DataSetColumn="ContragentDocNumber" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ManufacturerId" DataSetColumn="ManufacturerId" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="RetailPrice" DataSetColumn="RetailPrice" />
              <Mapping SourceColumn="Qntty" DataSetColumn="Qntty" />
              <Mapping SourceColumn="Barcode" DataSetColumn="Barcode" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="Expiration" DataSetColumn="Expiration" />
              <Mapping SourceColumn="SupplierDocId" DataSetColumn="SupplierDocId" />
              <Mapping SourceColumn="AllowUnPack" DataSetColumn="AllowUnPack" />
              <Mapping SourceColumn="RetailPack" DataSetColumn="RetailPack" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CIATableAdapter" GeneratorDataComponentClassName="CIATableAdapter" Name="CIA" UserDataComponentName="CIATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CiaConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     CODE, KOLVO, PRICE_OPL, SUM_BASE, NDS_PR, NDS_SUM, SUM_OPL, NSP, PRICE_BASE, PRO, PRO_NNDS, PRO_PR, NC_IMP_PR, NC_IMP_SUM, 
                      NC_OPT_PR, NC_OPT_SUM, PRICE_OPT, PRICE_REES, DATE_REES, SERIES, WEIGHT, DCODE, DATE_DOC, GTD, ID, SERT_N, ID_APTEKA, ID_FILIAL, 
                      PRICE_O, XCONCEPT, TAM_PER, TAM_SUM, PRODUCT, PRODUCER, SROK_S, NSP_PR, EAN13, FARMCODE, SE_NUM, SE_ORG, SE_SROK
FROM         B_210606</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CODE" DataSetColumn="CODE" />
              <Mapping SourceColumn="KOLVO" DataSetColumn="KOLVO" />
              <Mapping SourceColumn="PRICE_OPL" DataSetColumn="PRICE_OPL" />
              <Mapping SourceColumn="SUM_BASE" DataSetColumn="SUM_BASE" />
              <Mapping SourceColumn="NDS_PR" DataSetColumn="NDS_PR" />
              <Mapping SourceColumn="NDS_SUM" DataSetColumn="NDS_SUM" />
              <Mapping SourceColumn="SUM_OPL" DataSetColumn="SUM_OPL" />
              <Mapping SourceColumn="NSP" DataSetColumn="NSP" />
              <Mapping SourceColumn="PRICE_BASE" DataSetColumn="PRICE_BASE" />
              <Mapping SourceColumn="PRO" DataSetColumn="PRO" />
              <Mapping SourceColumn="PRO_NNDS" DataSetColumn="PRO_NNDS" />
              <Mapping SourceColumn="PRO_PR" DataSetColumn="PRO_PR" />
              <Mapping SourceColumn="NC_IMP_PR" DataSetColumn="NC_IMP_PR" />
              <Mapping SourceColumn="NC_IMP_SUM" DataSetColumn="NC_IMP_SUM" />
              <Mapping SourceColumn="NC_OPT_PR" DataSetColumn="NC_OPT_PR" />
              <Mapping SourceColumn="NC_OPT_SUM" DataSetColumn="NC_OPT_SUM" />
              <Mapping SourceColumn="PRICE_OPT" DataSetColumn="PRICE_OPT" />
              <Mapping SourceColumn="PRICE_REES" DataSetColumn="PRICE_REES" />
              <Mapping SourceColumn="DATE_REES" DataSetColumn="DATE_REES" />
              <Mapping SourceColumn="SERIES" DataSetColumn="SERIES" />
              <Mapping SourceColumn="WEIGHT" DataSetColumn="WEIGHT" />
              <Mapping SourceColumn="DCODE" DataSetColumn="DCODE" />
              <Mapping SourceColumn="DATE_DOC" DataSetColumn="DATE_DOC" />
              <Mapping SourceColumn="GTD" DataSetColumn="GTD" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SERT_N" DataSetColumn="SERT_N" />
              <Mapping SourceColumn="ID_APTEKA" DataSetColumn="ID_APTEKA" />
              <Mapping SourceColumn="ID_FILIAL" DataSetColumn="ID_FILIAL" />
              <Mapping SourceColumn="PRICE_O" DataSetColumn="PRICE_O" />
              <Mapping SourceColumn="XCONCEPT" DataSetColumn="XCONCEPT" />
              <Mapping SourceColumn="TAM_PER" DataSetColumn="TAM_PER" />
              <Mapping SourceColumn="TAM_SUM" DataSetColumn="TAM_SUM" />
              <Mapping SourceColumn="PRODUCT" DataSetColumn="PRODUCT" />
              <Mapping SourceColumn="PRODUCER" DataSetColumn="PRODUCER" />
              <Mapping SourceColumn="SROK_S" DataSetColumn="SROK_S" />
              <Mapping SourceColumn="NSP_PR" DataSetColumn="NSP_PR" />
              <Mapping SourceColumn="EAN13" DataSetColumn="EAN13" />
              <Mapping SourceColumn="FARMCODE" DataSetColumn="FARMCODE" />
              <Mapping SourceColumn="SE_NUM" DataSetColumn="SE_NUM" />
              <Mapping SourceColumn="SE_ORG" DataSetColumn="SE_ORG" />
              <Mapping SourceColumn="SE_SROK" DataSetColumn="SE_SROK" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RetailMarkupWeightTableAdapter" GeneratorDataComponentClassName="RetailMarkupWeightTableAdapter" Name="RetailMarkupWeight" UserDataComponentName="RetailMarkupWeightTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="Zeta.CD.InputLines" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT RetailMarkup, COUNT(RetailMarkup) AS MarkupWeight 
FROM CD.InputLines
WHERE CD.InputLines.DocId=@DocId
GROUP BY RetailMarkup
ORDER BY MarkupWeight</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DocId" ColumnName="DocId" DataSourceName="Zeta.CD.InputLines" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RetailMarkup" DataSetColumn="RetailMarkup" />
              <Mapping SourceColumn="MarkupWeight" DataSetColumn="MarkupWeight" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CO.Catalog" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="GoodsMarkUp" MethodsParameterType="SQL" Modifier="Public" Name="GoodsMarkUp" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GoodsMarkUp">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="True">
                <CommandText>SELECT     CO.Catalog.MarkUp
FROM         CA.Assortment INNER JOIN
                      CO.Catalog ON CA.Assortment.CatalogId = CO.Catalog.Id INNER JOIN
                      CA.Goods ON CA.Assortment.Id = CA.Goods.AssortmentId
WHERE     (CA.Goods.Id = @goodsId)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="False" AutogeneratedName="goodsId" ColumnName="Id" DataSourceName="DIApteka.CA.Goods" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@goodsId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CD.Parties" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="previsionPrice" MethodsParameterType="CLR" Modifier="Public" Name="previsionPrice" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="previsionPrice">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="True">
                <CommandText>SELECT        RetailPrice
FROM            CD.Parties AS p1
WHERE        (Id =
                             (SELECT        MAX(p2.Id) AS Expr1
                               FROM            CD.Parties AS p2 INNER JOIN
                                                         CA.Documents AS d ON d.Id = p2.DocId AND d.Id &lt;&gt; 9808 AND (d.ParentId &lt;&gt; 9808 OR
                                                         d.ParentId IS NULL)
                               WHERE        (p2.MD &lt; DATEADD(d, - 1, GETDATE())) AND (p2.GoodsId = @GoodsId) AND (p2.DepartmentId = @DepartmentId)))</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="False" AutogeneratedName="GoodsId" ColumnName="GoodsId" DataSourceName="DIApteka.CD.Parties" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GoodsId" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="DepartmentId" ColumnName="DepartmentId" DataSourceName="DIApteka.CD.Parties" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DepartmentId" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CO.Departments" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="DepartamentName" MethodsParameterType="CLR" Modifier="Public" Name="DepartamentName" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="DepartamentName">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="True">
                <CommandText>SELECT     d.Name
FROM         PR.DepartmentOptions AS o INNER JOIN
                      CO.Departments AS d ON d.Id = o.DepartmentId</CommandText>
                <Parameters>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.SupplierInvoiceLinesDelete" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="SupplierInvoiceLinesDelete" MethodsParameterType="CLR" Modifier="Public" Name="SupplierInvoiceLinesDelete" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="SupplierInvoiceLinesDelete">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.SupplierInvoiceLinesDelete</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.dbo.SupplierInvoiceDocDelete" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="SupplierInvoiceDocDelete" MethodsParameterType="CLR" Modifier="Public" Name="SupplierInvoiceDocDelete" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="SupplierInvoiceDocDelete">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.SupplierInvoiceDocDelete</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DIApteka.CD.Parties" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="previsionPrice2" MethodsParameterType="CLR" Modifier="Public" Name="previsionPrice2" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="previsionPrice2">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="True">
                <CommandText>SELECT        RetailPrice
FROM            CD.Parties AS p1
WHERE        (Id =
                             (SELECT        MAX(p2.Id) AS Expr1
                               FROM            CD.Parties AS p2 INNER JOIN
                                                         CA.Documents AS d ON d.Id = p2.DocId AND d.Id &lt;&gt; 9808 AND (d.ParentId &lt;&gt; 9808 OR
                                                         d.ParentId IS NULL)
                               WHERE        (p2.MD &lt; DATEADD(d, - 2, GETDATE())) AND (p2.GoodsId = @GoodsId) AND (p2.DepartmentId = @DepartmentId)))</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="False" AutogeneratedName="GoodsId" ColumnName="GoodsId" DataSourceName="DIApteka.CD.Parties" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GoodsId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GoodsId" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="DepartmentId" ColumnName="DepartmentId" DataSourceName="DIApteka.CD.Parties" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DepartmentId" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="waybillsData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msprop:Generator_UserDSName="waybillsData" msprop:Generator_DataSetName="waybillsData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Moron" msprop:Generator_UserTableName="Moron" msprop:Generator_RowDeletedName="MoronRowDeleted" msprop:Generator_RowChangedName="MoronRowChanged" msprop:Generator_RowClassName="MoronRow" msprop:Generator_RowChangingName="MoronRowChanging" msprop:Generator_RowEvArgName="MoronRowChangeEvent" msprop:Generator_RowEvHandlerName="MoronRowChangeEventHandler" msprop:Generator_TableClassName="MoronDataTable" msprop:Generator_TableVarName="tableMoron" msprop:Generator_RowDeletingName="MoronRowDeleting" msprop:Generator_TablePropName="Moron">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NUMNAK" msprop:Generator_UserColumnName="NUMNAK" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnNUMNAK" msprop:Generator_ColumnPropNameInTable="NUMNAKColumn" msprop:Generator_ColumnPropNameInRow="NUMNAK" type="xs:string" minOccurs="0" />
              <xs:element name="DATAGOT" msprop:Generator_UserColumnName="DATAGOT" msprop:Generator_ColumnVarNameInTable="columnDATAGOT" msprop:Generator_ColumnPropNameInRow="DATAGOT" msprop:Generator_ColumnPropNameInTable="DATAGOTColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="KODAPTEK" msprop:Generator_UserColumnName="KODAPTEK" msprop:Generator_ColumnVarNameInTable="columnKODAPTEK" msprop:Generator_ColumnPropNameInRow="KODAPTEK" msprop:Generator_ColumnPropNameInTable="KODAPTEKColumn" type="xs:double" minOccurs="0" />
              <xs:element name="KODPOSTAV" msprop:Generator_UserColumnName="KODPOSTAV" msprop:Generator_ColumnVarNameInTable="columnKODPOSTAV" msprop:Generator_ColumnPropNameInRow="KODPOSTAV" msprop:Generator_ColumnPropNameInTable="KODPOSTAVColumn" type="xs:double" minOccurs="0" />
              <xs:element name="KODNLKLEK" msprop:Generator_UserColumnName="KODNLKLEK" msprop:Generator_ColumnVarNameInTable="columnKODNLKLEK" msprop:Generator_ColumnPropNameInRow="KODNLKLEK" msprop:Generator_ColumnPropNameInTable="KODNLKLEKColumn" type="xs:double" minOccurs="0" />
              <xs:element name="EAN13" msprop:Generator_UserColumnName="EAN13" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="EAN13" msprop:Generator_ColumnPropNameInTable="EAN13Column" msprop:Generator_ColumnVarNameInTable="columnEAN13" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="26" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CENARAS" msprop:Generator_UserColumnName="CENARAS" msprop:Generator_ColumnVarNameInTable="columnCENARAS" msprop:Generator_ColumnPropNameInRow="CENARAS" msprop:Generator_ColumnPropNameInTable="CENARASColumn" type="xs:double" minOccurs="0" />
              <xs:element name="CENARASDOL" msprop:Generator_UserColumnName="CENARASDOL" msprop:Generator_ColumnVarNameInTable="columnCENARASDOL" msprop:Generator_ColumnPropNameInRow="CENARASDOL" msprop:Generator_ColumnPropNameInTable="CENARASDOLColumn" type="xs:double" minOccurs="0" />
              <xs:element name="CENAPRBNDS" msprop:Generator_UserColumnName="CENAPRBNDS" msprop:Generator_ColumnVarNameInTable="columnCENAPRBNDS" msprop:Generator_ColumnPropNameInRow="CENAPRBNDS" msprop:Generator_ColumnPropNameInTable="CENAPRBNDSColumn" type="xs:double" minOccurs="0" />
              <xs:element name="CENAPROD" msprop:Generator_UserColumnName="CENAPROD" msprop:Generator_ColumnVarNameInTable="columnCENAPROD" msprop:Generator_ColumnPropNameInRow="CENAPROD" msprop:Generator_ColumnPropNameInTable="CENAPRODColumn" type="xs:double" minOccurs="0" />
              <xs:element name="COUNT" msprop:Generator_UserColumnName="COUNT" msprop:Generator_ColumnVarNameInTable="columnCOUNT" msprop:Generator_ColumnPropNameInRow="COUNT" msprop:Generator_ColumnPropNameInTable="COUNTColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SERIJ" msprop:Generator_UserColumnName="SERIJ" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="SERIJ" msprop:Generator_ColumnPropNameInTable="SERIJColumn" msprop:Generator_ColumnVarNameInTable="columnSERIJ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="22" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SROKGOD" msprop:Generator_UserColumnName="SROKGOD" msprop:Generator_ColumnVarNameInTable="columnSROKGOD" msprop:Generator_ColumnPropNameInRow="SROKGOD" msprop:Generator_ColumnPropNameInTable="SROKGODColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PRZPROD" msprop:Generator_UserColumnName="PRZPROD" msprop:Generator_ColumnVarNameInTable="columnPRZPROD" msprop:Generator_ColumnPropNameInRow="PRZPROD" msprop:Generator_ColumnPropNameInTable="PRZPRODColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NAMLEK" msprop:Generator_UserColumnName="NAMLEK" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NAMLEK" msprop:Generator_ColumnPropNameInTable="NAMLEKColumn" msprop:Generator_ColumnVarNameInTable="columnNAMLEK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KODSTN" msprop:Generator_UserColumnName="KODSTN" msprop:Generator_ColumnVarNameInTable="columnKODSTN" msprop:Generator_ColumnPropNameInRow="KODSTN" msprop:Generator_ColumnPropNameInTable="KODSTNColumn" type="xs:double" minOccurs="0" />
              <xs:element name="KODZAVOD" msprop:Generator_UserColumnName="KODZAVOD" msprop:Generator_ColumnVarNameInTable="columnKODZAVOD" msprop:Generator_ColumnPropNameInRow="KODZAVOD" msprop:Generator_ColumnPropNameInTable="KODZAVODColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NAMSTRANA" msprop:Generator_UserColumnName="NAMSTRANA" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NAMSTRANA" msprop:Generator_ColumnPropNameInTable="NAMSTRANAColumn" msprop:Generator_ColumnVarNameInTable="columnNAMSTRANA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NAMZAVOD" msprop:Generator_UserColumnName="NAMZAVOD" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NAMZAVOD" msprop:Generator_ColumnPropNameInTable="NAMZAVODColumn" msprop:Generator_ColumnVarNameInTable="columnNAMZAVOD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VID" msprop:Generator_UserColumnName="VID" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="VID" msprop:Generator_ColumnPropNameInTable="VIDColumn" msprop:Generator_ColumnVarNameInTable="columnVID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KOLUP" msprop:Generator_UserColumnName="KOLUP" msprop:Generator_ColumnVarNameInTable="columnKOLUP" msprop:Generator_ColumnPropNameInRow="KOLUP" msprop:Generator_ColumnPropNameInTable="KOLUPColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRCNDS" msprop:Generator_UserColumnName="PRCNDS" msprop:Generator_ColumnVarNameInTable="columnPRCNDS" msprop:Generator_ColumnPropNameInRow="PRCNDS" msprop:Generator_ColumnPropNameInTable="PRCNDSColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRCNSP" msprop:Generator_UserColumnName="PRCNSP" msprop:Generator_ColumnVarNameInTable="columnPRCNSP" msprop:Generator_ColumnPropNameInRow="PRCNSP" msprop:Generator_ColumnPropNameInTable="PRCNSPColumn" type="xs:double" minOccurs="0" />
              <xs:element name="OBAS" msprop:Generator_UserColumnName="OBAS" msprop:Generator_ColumnVarNameInTable="columnOBAS" msprop:Generator_ColumnPropNameInRow="OBAS" msprop:Generator_ColumnPropNameInTable="OBASColumn" type="xs:double" minOccurs="0" />
              <xs:element name="CENAREE" msprop:Generator_UserColumnName="CENAREE" msprop:Generator_ColumnVarNameInTable="columnCENAREE" msprop:Generator_ColumnPropNameInRow="CENAREE" msprop:Generator_ColumnPropNameInTable="CENAREEColumn" type="xs:double" minOccurs="0" />
              <xs:element name="DATAREE" msprop:Generator_UserColumnName="DATAREE" msprop:Generator_ColumnVarNameInTable="columnDATAREE" msprop:Generator_ColumnPropNameInRow="DATAREE" msprop:Generator_ColumnPropNameInTable="DATAREEColumn" type="xs:dateTime" default="1900-01-01T00:00:00+03:00" minOccurs="0" />
              <xs:element name="CENAREC" msprop:Generator_UserColumnName="CENAREC" msprop:Generator_ColumnVarNameInTable="columnCENAREC" msprop:Generator_ColumnPropNameInRow="CENAREC" msprop:Generator_ColumnPropNameInTable="CENARECColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NUMDECLARE" msprop:Generator_UserColumnName="NUMDECLARE" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NUMDECLARE" msprop:Generator_ColumnPropNameInTable="NUMDECLAREColumn" msprop:Generator_ColumnVarNameInTable="columnNUMDECLARE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="58" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMBER" msprop:Generator_UserColumnName="NUMBER" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NUMBER" msprop:Generator_ColumnPropNameInTable="NUMBERColumn" msprop:Generator_ColumnVarNameInTable="columnNUMBER" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="240" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SROK" msprop:Generator_UserColumnName="SROK" msprop:Generator_ColumnVarNameInTable="columnSROK" msprop:Generator_ColumnPropNameInRow="SROK" msprop:Generator_ColumnPropNameInTable="SROKColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NAMEPRINT" msprop:Generator_UserColumnName="NAMEPRINT" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="NAMEPRINT" msprop:Generator_ColumnPropNameInTable="NAMEPRINTColumn" msprop:Generator_ColumnVarNameInTable="columnNAMEPRINT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KODORG" msprop:Generator_UserColumnName="KODORG" msprop:Generator_ColumnVarNameInTable="columnKODORG" msprop:Generator_ColumnPropNameInRow="KODORG" msprop:Generator_ColumnPropNameInTable="KODORGColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRZ_PRI" msprop:Generator_UserColumnName="PRZ_PRI" msprop:Generator_ColumnVarNameInTable="columnPRZ_PRI" msprop:Generator_ColumnPropNameInRow="PRZ_PRI" msprop:Generator_ColumnPropNameInTable="PRZ_PRIColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SUMBNDS" msprop:Generator_UserColumnName="SUMBNDS" msprop:Generator_ColumnVarNameInTable="columnSUMBNDS" msprop:Generator_ColumnPropNameInRow="SUMBNDS" msprop:Generator_ColumnPropNameInTable="SUMBNDSColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NDS10" msprop:Generator_UserColumnName="NDS10" msprop:Generator_ColumnVarNameInTable="columnNDS10" msprop:Generator_ColumnPropNameInRow="NDS10" msprop:Generator_ColumnPropNameInTable="NDS10Column" type="xs:double" minOccurs="0" />
              <xs:element name="NDS20" msprop:Generator_UserColumnName="NDS20" msprop:Generator_ColumnVarNameInTable="columnNDS20" msprop:Generator_ColumnPropNameInRow="NDS20" msprop:Generator_ColumnPropNameInTable="NDS20Column" type="xs:double" minOccurs="0" />
              <xs:element name="SUMNDS10" msprop:Generator_UserColumnName="SUMNDS10" msprop:Generator_ColumnVarNameInTable="columnSUMNDS10" msprop:Generator_ColumnPropNameInRow="SUMNDS10" msprop:Generator_ColumnPropNameInTable="SUMNDS10Column" type="xs:double" minOccurs="0" />
              <xs:element name="SUMNDS20" msprop:Generator_UserColumnName="SUMNDS20" msprop:Generator_ColumnVarNameInTable="columnSUMNDS20" msprop:Generator_ColumnPropNameInRow="SUMNDS20" msprop:Generator_ColumnPropNameInTable="SUMNDS20Column" type="xs:double" minOccurs="0" />
              <xs:element name="SUMNDS0" msprop:Generator_UserColumnName="SUMNDS0" msprop:Generator_ColumnVarNameInTable="columnSUMNDS0" msprop:Generator_ColumnPropNameInRow="SUMNDS0" msprop:Generator_ColumnPropNameInTable="SUMNDS0Column" type="xs:double" minOccurs="0" />
              <xs:element name="NACIMP" msprop:Generator_UserColumnName="NACIMP" msprop:Generator_ColumnVarNameInTable="columnNACIMP" msprop:Generator_ColumnPropNameInRow="NACIMP" msprop:Generator_ColumnPropNameInTable="NACIMPColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NACOPT" msprop:Generator_UserColumnName="NACOPT" msprop:Generator_ColumnVarNameInTable="columnNACOPT" msprop:Generator_ColumnPropNameInRow="NACOPT" msprop:Generator_ColumnPropNameInTable="NACOPTColumn" type="xs:double" minOccurs="0" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SupplierGoodsId" msprop:Generator_UserColumnName="SupplierGoodsId" msprop:Generator_ColumnPropNameInRow="SupplierGoodsId" msprop:Generator_ColumnVarNameInTable="columnSupplierGoodsId" msprop:Generator_ColumnPropNameInTable="SupplierGoodsIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierInvoiceDocInsert" msprop:Generator_UserTableName="SupplierInvoiceDocInsert" msprop:Generator_RowDeletedName="SupplierInvoiceDocInsertRowDeleted" msprop:Generator_RowChangedName="SupplierInvoiceDocInsertRowChanged" msprop:Generator_RowClassName="SupplierInvoiceDocInsertRow" msprop:Generator_RowChangingName="SupplierInvoiceDocInsertRowChanging" msprop:Generator_RowEvArgName="SupplierInvoiceDocInsertRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierInvoiceDocInsertRowChangeEventHandler" msprop:Generator_TableClassName="SupplierInvoiceDocInsertDataTable" msprop:Generator_TableVarName="tableSupplierInvoiceDocInsert" msprop:Generator_RowDeletingName="SupplierInvoiceDocInsertRowDeleting" msprop:Generator_TablePropName="SupplierInvoiceDocInsert">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="GId" msprop:Generator_UserColumnName="GId" msprop:Generator_ColumnVarNameInTable="columnGId" msprop:Generator_ColumnPropNameInRow="GId" msprop:Generator_ColumnPropNameInTable="GIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DocTypeId" msprop:Generator_UserColumnName="DocTypeId" msprop:Generator_ColumnVarNameInTable="columnDocTypeId" msprop:Generator_ColumnPropNameInRow="DocTypeId" msprop:Generator_ColumnPropNameInTable="DocTypeIdColumn" type="xs:int" />
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentId" msprop:Generator_UserColumnName="ContragentId" msprop:Generator_ColumnVarNameInTable="columnContragentId" msprop:Generator_ColumnPropNameInRow="ContragentId" msprop:Generator_ColumnPropNameInTable="ContragentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ContragentDocDate" msprop:Generator_UserColumnName="ContragentDocDate" msprop:Generator_ColumnVarNameInTable="columnContragentDocDate" msprop:Generator_ColumnPropNameInRow="ContragentDocDate" msprop:Generator_ColumnPropNameInTable="ContragentDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaymentDate" msprop:Generator_UserColumnName="PaymentDate" msprop:Generator_ColumnVarNameInTable="columnPaymentDate" msprop:Generator_ColumnPropNameInRow="PaymentDate" msprop:Generator_ColumnPropNameInTable="PaymentDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DepartmentUserId" msprop:Generator_UserColumnName="DepartmentUserId" msprop:Generator_ColumnVarNameInTable="columnDepartmentUserId" msprop:Generator_ColumnPropNameInRow="DepartmentUserId" msprop:Generator_ColumnPropNameInTable="DepartmentUserIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierInvoiceLinesInsert" msprop:Generator_UserTableName="SupplierInvoiceLinesInsert" msprop:Generator_RowDeletedName="SupplierInvoiceLinesInsertRowDeleted" msprop:Generator_RowChangedName="SupplierInvoiceLinesInsertRowChanged" msprop:Generator_RowClassName="SupplierInvoiceLinesInsertRow" msprop:Generator_RowChangingName="SupplierInvoiceLinesInsertRowChanging" msprop:Generator_RowEvArgName="SupplierInvoiceLinesInsertRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierInvoiceLinesInsertRowChangeEventHandler" msprop:Generator_TableClassName="SupplierInvoiceLinesInsertDataTable" msprop:Generator_TableVarName="tableSupplierInvoiceLinesInsert" msprop:Generator_RowDeletingName="SupplierInvoiceLinesInsertRowDeleting" msprop:Generator_TablePropName="SupplierInvoiceLinesInsert">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocId" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocQntty" msprop:Generator_UserColumnName="DocQntty" msprop:Generator_ColumnVarNameInTable="columnDocQntty" msprop:Generator_ColumnPropNameInRow="DocQntty" msprop:Generator_ColumnPropNameInTable="DocQnttyColumn" type="xs:int" />
              <xs:element name="Qntty" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailSum" msprop:Generator_UserColumnName="RetailSum" msprop:Generator_ColumnVarNameInTable="columnRetailSum" msprop:Generator_ColumnPropNameInRow="RetailSum" msprop:Generator_ColumnPropNameInTable="RetailSumColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SupplierGoodsId" msprop:Generator_UserColumnName="SupplierGoodsId" msprop:Generator_ColumnVarNameInTable="columnSupplierGoodsId" msprop:Generator_ColumnPropNameInRow="SupplierGoodsId" msprop:Generator_ColumnPropNameInTable="SupplierGoodsIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ManufacturerPrice" msprop:Generator_UserColumnName="ManufacturerPrice" msprop:Generator_ColumnVarNameInTable="columnManufacturerPrice" msprop:Generator_ColumnPropNameInRow="ManufacturerPrice" msprop:Generator_ColumnPropNameInTable="ManufacturerPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SupplierPrice" msprop:Generator_UserColumnName="SupplierPrice" msprop:Generator_ColumnVarNameInTable="columnSupplierPrice" msprop:Generator_ColumnPropNameInRow="SupplierPrice" msprop:Generator_ColumnPropNameInTable="SupplierPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ImportMarkup" msprop:Generator_UserColumnName="ImportMarkup" msprop:Generator_ColumnVarNameInTable="columnImportMarkup" msprop:Generator_ColumnPropNameInRow="ImportMarkup" msprop:Generator_ColumnPropNameInTable="ImportMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SupplierMarkup" msprop:Generator_UserColumnName="SupplierMarkup" msprop:Generator_ColumnVarNameInTable="columnSupplierMarkup" msprop:Generator_ColumnPropNameInRow="SupplierMarkup" msprop:Generator_ColumnPropNameInTable="SupplierMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="BatchNumber" msprop:Generator_UserColumnName="BatchNumber" msprop:Generator_ColumnVarNameInTable="columnBatchNumber" msprop:Generator_ColumnPropNameInRow="BatchNumber" msprop:Generator_ColumnPropNameInTable="BatchNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReadyBefore" msprop:Generator_UserColumnName="ReadyBefore" msprop:Generator_ColumnVarNameInTable="columnReadyBefore" msprop:Generator_ColumnPropNameInRow="ReadyBefore" msprop:Generator_ColumnPropNameInTable="ReadyBeforeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MadeDate" msprop:Generator_UserColumnName="MadeDate" msprop:Generator_ColumnVarNameInTable="columnMadeDate" msprop:Generator_ColumnPropNameInRow="MadeDate" msprop:Generator_ColumnPropNameInTable="MadeDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NDSTax" msprop:Generator_UserColumnName="NDSTax" msprop:Generator_ColumnVarNameInTable="columnNDSTax" msprop:Generator_ColumnPropNameInRow="NDSTax" msprop:Generator_ColumnPropNameInTable="NDSTaxColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="NDSValue" msprop:Generator_UserColumnName="NDSValue" msprop:Generator_ColumnVarNameInTable="columnNDSValue" msprop:Generator_ColumnPropNameInRow="NDSValue" msprop:Generator_ColumnPropNameInTable="NDSValueColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrPrice" msprop:Generator_UserColumnName="ReestrPrice" msprop:Generator_ColumnVarNameInTable="columnReestrPrice" msprop:Generator_ColumnPropNameInRow="ReestrPrice" msprop:Generator_ColumnPropNameInTable="ReestrPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrDate" msprop:Generator_UserColumnName="ReestrDate" msprop:Generator_ColumnVarNameInTable="columnReestrDate" msprop:Generator_ColumnPropNameInRow="ReestrDate" msprop:Generator_ColumnPropNameInTable="ReestrDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GTDNumber" msprop:Generator_UserColumnName="GTDNumber" msprop:Generator_ColumnVarNameInTable="columnGTDNumber" msprop:Generator_ColumnPropNameInRow="GTDNumber" msprop:Generator_ColumnPropNameInTable="GTDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CertificateNumber" msprop:Generator_UserColumnName="CertificateNumber" msprop:Generator_ColumnVarNameInTable="columnCertificateNumber" msprop:Generator_ColumnPropNameInRow="CertificateNumber" msprop:Generator_ColumnPropNameInTable="CertificateNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CertificateDate" msprop:Generator_UserColumnName="CertificateDate" msprop:Generator_ColumnVarNameInTable="columnCertificateDate" msprop:Generator_ColumnPropNameInRow="CertificateDate" msprop:Generator_ColumnPropNameInTable="CertificateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CertificateOrgId" msprop:Generator_UserColumnName="CertificateOrgId" msprop:Generator_ColumnVarNameInTable="columnCertificateOrgId" msprop:Generator_ColumnPropNameInRow="CertificateOrgId" msprop:Generator_ColumnPropNameInTable="CertificateOrgIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailMarkup" msprop:Generator_UserColumnName="RetailMarkup" msprop:Generator_ColumnVarNameInTable="columnRetailMarkup" msprop:Generator_ColumnPropNameInRow="RetailMarkup" msprop:Generator_ColumnPropNameInTable="RetailMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SupplierSumNOTAX" msprop:Generator_UserColumnName="SupplierSumNOTAX" msprop:Generator_ColumnVarNameInTable="columnSupplierSumNOTAX" msprop:Generator_ColumnPropNameInRow="SupplierSumNOTAX" msprop:Generator_ColumnPropNameInTable="SupplierSumNOTAXColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Documents" msprop:Generator_UserTableName="Documents" msprop:Generator_RowDeletedName="DocumentsRowDeleted" msprop:Generator_RowChangedName="DocumentsRowChanged" msprop:Generator_RowClassName="DocumentsRow" msprop:Generator_RowChangingName="DocumentsRowChanging" msprop:Generator_RowEvArgName="DocumentsRowChangeEvent" msprop:Generator_RowEvHandlerName="DocumentsRowChangeEventHandler" msprop:Generator_TableClassName="DocumentsDataTable" msprop:Generator_TableVarName="tableDocuments" msprop:Generator_RowDeletingName="DocumentsRowDeleting" msprop:Generator_TablePropName="Documents">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentDocDate" msprop:Generator_UserColumnName="ContragentDocDate" msprop:Generator_ColumnPropNameInRow="ContragentDocDate" msprop:Generator_ColumnVarNameInTable="columnContragentDocDate" msprop:Generator_ColumnPropNameInTable="ContragentDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ord" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ord" msprop:Generator_ColumnVarNameInTable="columnord" msprop:Generator_ColumnPropNameInRow="ord" msprop:Generator_ColumnPropNameInTable="ordColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CurrentNakl" msprop:Generator_UserTableName="CurrentNakl" msprop:Generator_RowDeletedName="CurrentNaklRowDeleted" msprop:Generator_RowChangedName="CurrentNaklRowChanged" msprop:Generator_RowClassName="CurrentNaklRow" msprop:Generator_RowChangingName="CurrentNaklRowChanging" msprop:Generator_RowEvArgName="CurrentNaklRowChangeEvent" msprop:Generator_RowEvHandlerName="CurrentNaklRowChangeEventHandler" msprop:Generator_TableClassName="CurrentNaklDataTable" msprop:Generator_TableVarName="tableCurrentNakl" msprop:Generator_RowDeletingName="CurrentNaklRowDeleting" msprop:Generator_TablePropName="CurrentNakl">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="ManufacturerPrice" msprop:Generator_UserColumnName="ManufacturerPrice" msprop:Generator_ColumnVarNameInTable="columnManufacturerPrice" msprop:Generator_ColumnPropNameInRow="ManufacturerPrice" msprop:Generator_ColumnPropNameInTable="ManufacturerPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SupplierPrice" msprop:Generator_UserColumnName="SupplierPrice" msprop:Generator_ColumnVarNameInTable="columnSupplierPrice" msprop:Generator_ColumnPropNameInRow="SupplierPrice" msprop:Generator_ColumnPropNameInTable="SupplierPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NDSValue" msprop:Generator_UserColumnName="NDSValue" msprop:Generator_ColumnVarNameInTable="columnNDSValue" msprop:Generator_ColumnPropNameInRow="NDSValue" msprop:Generator_ColumnPropNameInTable="NDSValueColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NDSTax" msprop:Generator_UserColumnName="NDSTax" msprop:Generator_ColumnVarNameInTable="columnNDSTax" msprop:Generator_ColumnPropNameInRow="NDSTax" msprop:Generator_ColumnPropNameInTable="NDSTaxColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="RetailMarkup" msprop:Generator_UserColumnName="RetailMarkup" msprop:Generator_ColumnVarNameInTable="columnRetailMarkup" msprop:Generator_ColumnPropNameInRow="RetailMarkup" msprop:Generator_ColumnPropNameInTable="RetailMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ReadyBefore" msprop:Generator_UserColumnName="ReadyBefore" msprop:Generator_ColumnVarNameInTable="columnReadyBefore" msprop:Generator_ColumnPropNameInRow="ReadyBefore" msprop:Generator_ColumnPropNameInTable="ReadyBeforeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MadeDate" msprop:Generator_UserColumnName="MadeDate" msprop:Generator_ColumnVarNameInTable="columnMadeDate" msprop:Generator_ColumnPropNameInRow="MadeDate" msprop:Generator_ColumnPropNameInTable="MadeDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ReestrPrice" msprop:Generator_UserColumnName="ReestrPrice" msprop:Generator_ColumnVarNameInTable="columnReestrPrice" msprop:Generator_ColumnPropNameInRow="ReestrPrice" msprop:Generator_ColumnPropNameInTable="ReestrPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrDate" msprop:Generator_UserColumnName="ReestrDate" msprop:Generator_ColumnVarNameInTable="columnReestrDate" msprop:Generator_ColumnPropNameInRow="ReestrDate" msprop:Generator_ColumnPropNameInTable="ReestrDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DocQntty" msprop:Generator_UserColumnName="DocQntty" msprop:Generator_ColumnVarNameInTable="columnDocQntty" msprop:Generator_ColumnPropNameInRow="DocQntty" msprop:Generator_ColumnPropNameInTable="DocQnttyColumn" type="xs:int" />
              <xs:element name="DocId" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Count" msprop:Generator_UserColumnName="Count" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInTable="CountColumn" type="xs:int" />
              <xs:element name="GNVLS" msprop:Generator_UserColumnName="GNVLS" msprop:Generator_ColumnPropNameInRow="GNVLS" msprop:Generator_ColumnVarNameInTable="columnGNVLS" msprop:Generator_ColumnPropNameInTable="GNVLSColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="RetailPriceWithNDS" msprop:Generator_UserColumnName="RetailPriceWithNDS" msprop:Generator_ColumnPropNameInRow="RetailPriceWithNDS" msprop:Generator_ColumnVarNameInTable="columnRetailPriceWithNDS" msprop:Generator_ColumnPropNameInTable="RetailPriceWithNDSColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PrevisionPrice2" msprop:Generator_UserColumnName="PrevisionPrice2" msprop:Generator_ColumnVarNameInTable="columnPrevisionPrice2" msprop:Generator_ColumnPropNameInRow="PrevisionPrice2" msprop:Generator_ColumnPropNameInTable="PrevisionPrice2Column" type="xs:decimal" minOccurs="0" />
              <xs:element name="PrevisionPrice" msprop:Generator_UserColumnName="PrevisionPrice" msprop:Generator_ColumnPropNameInRow="PrevisionPrice" msprop:Generator_ColumnVarNameInTable="columnPrevisionPrice" msprop:Generator_ColumnPropNameInTable="PrevisionPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentDocDate" msprop:Generator_UserColumnName="ContragentDocDate" msprop:Generator_ColumnVarNameInTable="columnContragentDocDate" msprop:Generator_ColumnPropNameInRow="ContragentDocDate" msprop:Generator_ColumnPropNameInTable="ContragentDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContragentId" msprop:Generator_UserColumnName="ContragentId" msprop:Generator_ColumnVarNameInTable="columnContragentId" msprop:Generator_ColumnPropNameInRow="ContragentId" msprop:Generator_ColumnPropNameInTable="ContragentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CertificateOrgId" msprop:Generator_UserColumnName="CertificateOrgId" msprop:Generator_ColumnVarNameInTable="columnCertificateOrgId" msprop:Generator_ColumnPropNameInRow="CertificateOrgId" msprop:Generator_ColumnPropNameInTable="CertificateOrgIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CertificateDate" msprop:Generator_UserColumnName="CertificateDate" msprop:Generator_ColumnVarNameInTable="columnCertificateDate" msprop:Generator_ColumnPropNameInRow="CertificateDate" msprop:Generator_ColumnPropNameInTable="CertificateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CertificateNumber" msprop:Generator_UserColumnName="CertificateNumber" msprop:Generator_ColumnVarNameInTable="columnCertificateNumber" msprop:Generator_ColumnPropNameInRow="CertificateNumber" msprop:Generator_ColumnPropNameInTable="CertificateNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BatchNumber" msprop:Generator_UserColumnName="BatchNumber" msprop:Generator_ColumnVarNameInTable="columnBatchNumber" msprop:Generator_ColumnPropNameInRow="BatchNumber" msprop:Generator_ColumnPropNameInTable="BatchNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GTDNumber" msprop:Generator_UserColumnName="GTDNumber" msprop:Generator_ColumnVarNameInTable="columnGTDNumber" msprop:Generator_ColumnPropNameInRow="GTDNumber" msprop:Generator_ColumnPropNameInTable="GTDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SupplierMarkup" msprop:Generator_UserColumnName="SupplierMarkup" msprop:Generator_ColumnVarNameInTable="columnSupplierMarkup" msprop:Generator_ColumnPropNameInRow="SupplierMarkup" msprop:Generator_ColumnPropNameInTable="SupplierMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ImportMarkup" msprop:Generator_UserColumnName="ImportMarkup" msprop:Generator_ColumnVarNameInTable="columnImportMarkup" msprop:Generator_ColumnPropNameInRow="ImportMarkup" msprop:Generator_ColumnPropNameInTable="ImportMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SupplierGoodsId" msprop:Generator_UserColumnName="SupplierGoodsId" msprop:Generator_ColumnVarNameInTable="columnSupplierGoodsId" msprop:Generator_ColumnPropNameInRow="SupplierGoodsId" msprop:Generator_ColumnPropNameInTable="SupplierGoodsIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" msprop:Generator_ColumnPropNameInRow="BarCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Qntty" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SupplierSumNOTAX" msprop:Generator_UserColumnName="SupplierSumNOTAX" msprop:Generator_ColumnVarNameInTable="columnSupplierSumNOTAX" msprop:Generator_ColumnPropNameInRow="SupplierSumNOTAX" msprop:Generator_ColumnPropNameInTable="SupplierSumNOTAXColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SamsonPrice" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SamsonPrice" msprop:Generator_ColumnPropNameInRow="SamsonPrice" msprop:Generator_ColumnVarNameInTable="columnSamsonPrice" msprop:Generator_ColumnPropNameInTable="SamsonPriceColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PartiesUpdate" msprop:Generator_UserTableName="PartiesUpdate" msprop:Generator_RowDeletedName="PartiesUpdateRowDeleted" msprop:Generator_RowChangedName="PartiesUpdateRowChanged" msprop:Generator_RowClassName="PartiesUpdateRow" msprop:Generator_RowChangingName="PartiesUpdateRowChanging" msprop:Generator_RowEvArgName="PartiesUpdateRowChangeEvent" msprop:Generator_RowEvHandlerName="PartiesUpdateRowChangeEventHandler" msprop:Generator_TableClassName="PartiesUpdateDataTable" msprop:Generator_TableVarName="tablePartiesUpdate" msprop:Generator_RowDeletingName="PartiesUpdateRowDeleting" msprop:Generator_TablePropName="PartiesUpdate">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocId" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" />
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InputLineId" msprop:Generator_UserColumnName="InputLineId" msprop:Generator_ColumnVarNameInTable="columnInputLineId" msprop:Generator_ColumnPropNameInRow="InputLineId" msprop:Generator_ColumnPropNameInTable="InputLineIdColumn" type="xs:int" />
              <xs:element name="Blocked" msprop:Generator_UserColumnName="Blocked" msprop:Generator_ColumnVarNameInTable="columnBlocked" msprop:Generator_ColumnPropNameInRow="Blocked" msprop:Generator_ColumnPropNameInTable="BlockedColumn" type="xs:boolean" />
              <xs:element name="RestQntty" msprop:Generator_UserColumnName="RestQntty" msprop:Generator_ColumnVarNameInTable="columnRestQntty" msprop:Generator_ColumnPropNameInRow="RestQntty" msprop:Generator_ColumnPropNameInTable="RestQnttyColumn" type="xs:int" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierInvoiceLinesUpdate" msprop:Generator_UserTableName="SupplierInvoiceLinesUpdate" msprop:Generator_RowDeletedName="SupplierInvoiceLinesUpdateRowDeleted" msprop:Generator_RowChangedName="SupplierInvoiceLinesUpdateRowChanged" msprop:Generator_RowClassName="SupplierInvoiceLinesUpdateRow" msprop:Generator_RowChangingName="SupplierInvoiceLinesUpdateRowChanging" msprop:Generator_RowEvArgName="SupplierInvoiceLinesUpdateRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierInvoiceLinesUpdateRowChangeEventHandler" msprop:Generator_TableClassName="SupplierInvoiceLinesUpdateDataTable" msprop:Generator_TableVarName="tableSupplierInvoiceLinesUpdate" msprop:Generator_RowDeletingName="SupplierInvoiceLinesUpdateRowDeleting" msprop:Generator_TablePropName="SupplierInvoiceLinesUpdate">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocId" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocQntty" msprop:Generator_UserColumnName="DocQntty" msprop:Generator_ColumnVarNameInTable="columnDocQntty" msprop:Generator_ColumnPropNameInRow="DocQntty" msprop:Generator_ColumnPropNameInTable="DocQnttyColumn" type="xs:int" />
              <xs:element name="Qntty" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailSum" msprop:Generator_UserColumnName="RetailSum" msprop:Generator_ColumnVarNameInTable="columnRetailSum" msprop:Generator_ColumnPropNameInRow="RetailSum" msprop:Generator_ColumnPropNameInTable="RetailSumColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SupplierGoodsId" msprop:Generator_UserColumnName="SupplierGoodsId" msprop:Generator_ColumnVarNameInTable="columnSupplierGoodsId" msprop:Generator_ColumnPropNameInRow="SupplierGoodsId" msprop:Generator_ColumnPropNameInTable="SupplierGoodsIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ManufacturerPrice" msprop:Generator_UserColumnName="ManufacturerPrice" msprop:Generator_ColumnVarNameInTable="columnManufacturerPrice" msprop:Generator_ColumnPropNameInRow="ManufacturerPrice" msprop:Generator_ColumnPropNameInTable="ManufacturerPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SupplierPrice" msprop:Generator_UserColumnName="SupplierPrice" msprop:Generator_ColumnVarNameInTable="columnSupplierPrice" msprop:Generator_ColumnPropNameInRow="SupplierPrice" msprop:Generator_ColumnPropNameInTable="SupplierPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ImportMarkup" msprop:Generator_UserColumnName="ImportMarkup" msprop:Generator_ColumnVarNameInTable="columnImportMarkup" msprop:Generator_ColumnPropNameInRow="ImportMarkup" msprop:Generator_ColumnPropNameInTable="ImportMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SupplierMarkup" msprop:Generator_UserColumnName="SupplierMarkup" msprop:Generator_ColumnVarNameInTable="columnSupplierMarkup" msprop:Generator_ColumnPropNameInRow="SupplierMarkup" msprop:Generator_ColumnPropNameInTable="SupplierMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="BatchNumber" msprop:Generator_UserColumnName="BatchNumber" msprop:Generator_ColumnVarNameInTable="columnBatchNumber" msprop:Generator_ColumnPropNameInRow="BatchNumber" msprop:Generator_ColumnPropNameInTable="BatchNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReadyBefore" msprop:Generator_UserColumnName="ReadyBefore" msprop:Generator_ColumnVarNameInTable="columnReadyBefore" msprop:Generator_ColumnPropNameInRow="ReadyBefore" msprop:Generator_ColumnPropNameInTable="ReadyBeforeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MadeDate" msprop:Generator_UserColumnName="MadeDate" msprop:Generator_ColumnVarNameInTable="columnMadeDate" msprop:Generator_ColumnPropNameInRow="MadeDate" msprop:Generator_ColumnPropNameInTable="MadeDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NDSTax" msprop:Generator_UserColumnName="NDSTax" msprop:Generator_ColumnVarNameInTable="columnNDSTax" msprop:Generator_ColumnPropNameInRow="NDSTax" msprop:Generator_ColumnPropNameInTable="NDSTaxColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="NDSValue" msprop:Generator_UserColumnName="NDSValue" msprop:Generator_ColumnVarNameInTable="columnNDSValue" msprop:Generator_ColumnPropNameInRow="NDSValue" msprop:Generator_ColumnPropNameInTable="NDSValueColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrPrice" msprop:Generator_UserColumnName="ReestrPrice" msprop:Generator_ColumnVarNameInTable="columnReestrPrice" msprop:Generator_ColumnPropNameInRow="ReestrPrice" msprop:Generator_ColumnPropNameInTable="ReestrPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrDate" msprop:Generator_UserColumnName="ReestrDate" msprop:Generator_ColumnVarNameInTable="columnReestrDate" msprop:Generator_ColumnPropNameInRow="ReestrDate" msprop:Generator_ColumnPropNameInTable="ReestrDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GTDNumber" msprop:Generator_UserColumnName="GTDNumber" msprop:Generator_ColumnVarNameInTable="columnGTDNumber" msprop:Generator_ColumnPropNameInRow="GTDNumber" msprop:Generator_ColumnPropNameInTable="GTDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CertificateNumber" msprop:Generator_UserColumnName="CertificateNumber" msprop:Generator_ColumnVarNameInTable="columnCertificateNumber" msprop:Generator_ColumnPropNameInRow="CertificateNumber" msprop:Generator_ColumnPropNameInTable="CertificateNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CertificateDate" msprop:Generator_UserColumnName="CertificateDate" msprop:Generator_ColumnVarNameInTable="columnCertificateDate" msprop:Generator_ColumnPropNameInRow="CertificateDate" msprop:Generator_ColumnPropNameInTable="CertificateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CertificateOrgId" msprop:Generator_UserColumnName="CertificateOrgId" msprop:Generator_ColumnVarNameInTable="columnCertificateOrgId" msprop:Generator_ColumnPropNameInRow="CertificateOrgId" msprop:Generator_ColumnPropNameInTable="CertificateOrgIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailMarkup" msprop:Generator_UserColumnName="RetailMarkup" msprop:Generator_ColumnVarNameInTable="columnRetailMarkup" msprop:Generator_ColumnPropNameInRow="RetailMarkup" msprop:Generator_ColumnPropNameInTable="RetailMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PartyId" msprop:Generator_UserColumnName="PartyId" msprop:Generator_ColumnPropNameInRow="PartyId" msprop:Generator_ColumnVarNameInTable="columnPartyId" msprop:Generator_ColumnPropNameInTable="PartyIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SupplierSumNOTAX" msprop:Generator_UserColumnName="SupplierSumNOTAX" msprop:Generator_ColumnVarNameInTable="columnSupplierSumNOTAX" msprop:Generator_ColumnPropNameInRow="SupplierSumNOTAX" msprop:Generator_ColumnPropNameInTable="SupplierSumNOTAXColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SZData" msprop:Generator_UserTableName="SZData" msprop:Generator_RowDeletedName="SZDataRowDeleted" msprop:Generator_RowChangedName="SZDataRowChanged" msprop:Generator_RowClassName="SZDataRow" msprop:Generator_RowChangingName="SZDataRowChanging" msprop:Generator_RowEvArgName="SZDataRowChangeEvent" msprop:Generator_RowEvHandlerName="SZDataRowChangeEventHandler" msprop:Generator_TableClassName="SZDataDataTable" msprop:Generator_TableVarName="tableSZData" msprop:Generator_RowDeletingName="SZDataRowDeleting" msprop:Generator_TablePropName="SZData">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn" default=" ">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pid" msdata:ReadOnly="true" msprop:Generator_UserColumnName="pid" msprop:Generator_ColumnPropNameInRow="pid" msprop:Generator_ColumnVarNameInTable="columnpid" msprop:Generator_ColumnPropNameInTable="pidColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SZDataDetail" msprop:Generator_UserTableName="SZDataDetail" msprop:Generator_RowDeletedName="SZDataDetailRowDeleted" msprop:Generator_RowChangedName="SZDataDetailRowChanged" msprop:Generator_RowClassName="SZDataDetailRow" msprop:Generator_RowChangingName="SZDataDetailRowChanging" msprop:Generator_RowEvArgName="SZDataDetailRowChangeEvent" msprop:Generator_RowEvHandlerName="SZDataDetailRowChangeEventHandler" msprop:Generator_TableClassName="SZDataDetailDataTable" msprop:Generator_TableVarName="tableSZDataDetail" msprop:Generator_RowDeletingName="SZDataDetailRowDeleting" msprop:Generator_TablePropName="SZDataDetail">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" />
              <xs:element name="RestQntty" msprop:Generator_UserColumnName="RestQntty" msprop:Generator_ColumnPropNameInRow="RestQntty" msprop:Generator_ColumnVarNameInTable="columnRestQntty" msprop:Generator_ColumnPropNameInTable="RestQnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DocId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="PartyId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="PartyId" msprop:Generator_ColumnPropNameInRow="PartyId" msprop:Generator_ColumnVarNameInTable="columnPartyId" msprop:Generator_ColumnPropNameInTable="PartyIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ContragentsLinks" msprop:Generator_UserTableName="ContragentsLinks" msprop:Generator_RowDeletedName="ContragentsLinksRowDeleted" msprop:Generator_RowChangedName="ContragentsLinksRowChanged" msprop:Generator_RowClassName="ContragentsLinksRow" msprop:Generator_RowChangingName="ContragentsLinksRowChanging" msprop:Generator_RowEvArgName="ContragentsLinksRowChangeEvent" msprop:Generator_RowEvHandlerName="ContragentsLinksRowChangeEventHandler" msprop:Generator_TableClassName="ContragentsLinksDataTable" msprop:Generator_TableVarName="tableContragentsLinks" msprop:Generator_RowDeletingName="ContragentsLinksRowDeleting" msprop:Generator_TablePropName="ContragentsLinks">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContragentGoodName" msprop:Generator_UserColumnName="ContragentGoodName" msprop:Generator_ColumnPropNameInRow="ContragentGoodName" msprop:Generator_ColumnVarNameInTable="columnContragentGoodName" msprop:Generator_ColumnPropNameInTable="ContragentGoodNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InnerGoodName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="InnerGoodName" msprop:Generator_ColumnPropNameInRow="InnerGoodName" msprop:Generator_ColumnVarNameInTable="columnInnerGoodName" msprop:Generator_ColumnPropNameInTable="InnerGoodNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InnerManufacturerName" msprop:Generator_UserColumnName="InnerManufacturerName" msprop:Generator_ColumnPropNameInRow="InnerManufacturerName" msprop:Generator_ColumnVarNameInTable="columnInnerManufacturerName" msprop:Generator_ColumnPropNameInTable="InnerManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InnerCountryName" msprop:Generator_UserColumnName="InnerCountryName" msprop:Generator_ColumnPropNameInRow="InnerCountryName" msprop:Generator_ColumnVarNameInTable="columnInnerCountryName" msprop:Generator_ColumnPropNameInTable="InnerCountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentCountryName" msprop:Generator_UserColumnName="ContragentCountryName" msprop:Generator_ColumnPropNameInRow="ContragentCountryName" msprop:Generator_ColumnVarNameInTable="columnContragentCountryName" msprop:Generator_ColumnPropNameInTable="ContragentCountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentManufacturerName" msprop:Generator_UserColumnName="ContragentManufacturerName" msprop:Generator_ColumnPropNameInRow="ContragentManufacturerName" msprop:Generator_ColumnVarNameInTable="columnContragentManufacturerName" msprop:Generator_ColumnPropNameInTable="ContragentManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierReturns" msprop:Generator_UserTableName="SupplierReturns" msprop:Generator_RowDeletedName="SupplierReturnsRowDeleted" msprop:Generator_RowChangedName="SupplierReturnsRowChanged" msprop:Generator_RowClassName="SupplierReturnsRow" msprop:Generator_RowChangingName="SupplierReturnsRowChanging" msprop:Generator_RowEvArgName="SupplierReturnsRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierReturnsRowChangeEventHandler" msprop:Generator_TableClassName="SupplierReturnsDataTable" msprop:Generator_TableVarName="tableSupplierReturns" msprop:Generator_RowDeletingName="SupplierReturnsRowDeleting" msprop:Generator_TablePropName="SupplierReturns">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn" msprop:Generator_ColumnVarNameInTable="columnDocNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SupplierId" msprop:Generator_UserColumnName="SupplierId" msprop:Generator_ColumnPropNameInRow="SupplierId" msprop:Generator_ColumnVarNameInTable="columnSupplierId" msprop:Generator_ColumnPropNameInTable="SupplierIdColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="SupplierName" msprop:Generator_UserColumnName="SupplierName" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="SupplierName" msprop:Generator_ColumnPropNameInTable="SupplierNameColumn" msprop:Generator_ColumnVarNameInTable="columnSupplierName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lines" msprop:Generator_UserColumnName="Lines" msprop:Generator_ColumnPropNameInRow="Lines" msprop:Generator_ColumnVarNameInTable="columnLines" msprop:Generator_ColumnPropNameInTable="LinesColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="DocSum" msprop:Generator_UserColumnName="DocSum" msprop:Generator_ColumnPropNameInRow="DocSum" msprop:Generator_ColumnVarNameInTable="columnDocSum" msprop:Generator_ColumnPropNameInTable="DocSumColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnVarNameInTable="columnNote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInTable="MWColumn" msprop:Generator_ColumnPropNameInRow="MW" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SetificatedOrg" msprop:Generator_UserTableName="SetificatedOrg" msprop:Generator_RowDeletedName="SetificatedOrgRowDeleted" msprop:Generator_RowChangedName="SetificatedOrgRowChanged" msprop:Generator_RowClassName="SetificatedOrgRow" msprop:Generator_RowChangingName="SetificatedOrgRowChanging" msprop:Generator_RowEvArgName="SetificatedOrgRowChangeEvent" msprop:Generator_RowEvHandlerName="SetificatedOrgRowChangeEventHandler" msprop:Generator_TableClassName="SetificatedOrgDataTable" msprop:Generator_TableVarName="tableSetificatedOrg" msprop:Generator_RowDeletingName="SetificatedOrgRowDeleting" msprop:Generator_TablePropName="SetificatedOrg">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierReturnLines" msprop:Generator_UserTableName="SupplierReturnLines" msprop:Generator_RowDeletedName="SupplierReturnLinesRowDeleted" msprop:Generator_RowChangedName="SupplierReturnLinesRowChanged" msprop:Generator_RowClassName="SupplierReturnLinesRow" msprop:Generator_RowChangingName="SupplierReturnLinesRowChanging" msprop:Generator_RowEvArgName="SupplierReturnLinesRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierReturnLinesRowChangeEventHandler" msprop:Generator_TableClassName="SupplierReturnLinesDataTable" msprop:Generator_TableVarName="tableSupplierReturnLines" msprop:Generator_RowDeletingName="SupplierReturnLinesRowDeleting" msprop:Generator_TablePropName="SupplierReturnLines">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocId" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" />
              <xs:element name="PartyId" msprop:Generator_UserColumnName="PartyId" msprop:Generator_ColumnPropNameInRow="PartyId" msprop:Generator_ColumnVarNameInTable="columnPartyId" msprop:Generator_ColumnPropNameInTable="PartyIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerId" msprop:Generator_UserColumnName="ManufacturerId" msprop:Generator_ColumnVarNameInTable="columnManufacturerId" msprop:Generator_ColumnPropNameInRow="ManufacturerId" msprop:Generator_ColumnPropNameInTable="ManufacturerIdColumn" type="xs:int" />
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" msprop:Generator_ColumnPropNameInRow="ManufacturerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" />
              <xs:element name="Qntty" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailSum" msprop:Generator_UserColumnName="RetailSum" msprop:Generator_ColumnPropNameInRow="RetailSum" msprop:Generator_ColumnVarNameInTable="columnRetailSum" msprop:Generator_ColumnPropNameInTable="RetailSumColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReturnLineId" msprop:Generator_UserColumnName="ReturnLineId" msprop:Generator_ColumnPropNameInRow="ReturnLineId" msprop:Generator_ColumnVarNameInTable="columnReturnLineId" msprop:Generator_ColumnPropNameInTable="ReturnLineIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnPropNameInRow="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInTable="MWColumn" msprop:Generator_ColumnPropNameInRow="MW">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SupplierDocId" msprop:Generator_UserColumnName="SupplierDocId" msprop:Generator_ColumnVarNameInTable="columnSupplierDocId" msprop:Generator_ColumnPropNameInRow="SupplierDocId" msprop:Generator_ColumnPropNameInTable="SupplierDocIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="vwGoodsDetailed" msprop:Generator_UserTableName="vwGoodsDetailed" msprop:Generator_RowDeletedName="vwGoodsDetailedRowDeleted" msprop:Generator_RowChangedName="vwGoodsDetailedRowChanged" msprop:Generator_RowClassName="vwGoodsDetailedRow" msprop:Generator_RowChangingName="vwGoodsDetailedRowChanging" msprop:Generator_RowEvArgName="vwGoodsDetailedRowChangeEvent" msprop:Generator_RowEvHandlerName="vwGoodsDetailedRowChangeEventHandler" msprop:Generator_TableClassName="vwGoodsDetailedDataTable" msprop:Generator_TableVarName="tablevwGoodsDetailed" msprop:Generator_RowDeletingName="vwGoodsDetailedRowDeleting" msprop:Generator_TablePropName="vwGoodsDetailed">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GoodsVsContragentsInsert" msprop:Generator_UserTableName="GoodsVsContragentsInsert" msprop:Generator_RowDeletedName="GoodsVsContragentsInsertRowDeleted" msprop:Generator_RowChangedName="GoodsVsContragentsInsertRowChanged" msprop:Generator_RowClassName="GoodsVsContragentsInsertRow" msprop:Generator_RowChangingName="GoodsVsContragentsInsertRowChanging" msprop:Generator_RowEvArgName="GoodsVsContragentsInsertRowChangeEvent" msprop:Generator_RowEvHandlerName="GoodsVsContragentsInsertRowChangeEventHandler" msprop:Generator_TableClassName="GoodsVsContragentsInsertDataTable" msprop:Generator_TableVarName="tableGoodsVsContragentsInsert" msprop:Generator_RowDeletingName="GoodsVsContragentsInsertRowDeleting" msprop:Generator_TablePropName="GoodsVsContragentsInsert">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GId" msprop:Generator_UserColumnName="GId" msprop:Generator_ColumnVarNameInTable="columnGId" msprop:Generator_ColumnPropNameInRow="GId" msprop:Generator_ColumnPropNameInTable="GIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ContragentId" msprop:Generator_UserColumnName="ContragentId" msprop:Generator_ColumnVarNameInTable="columnContragentId" msprop:Generator_ColumnPropNameInRow="ContragentId" msprop:Generator_ColumnPropNameInTable="ContragentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GoodsCode" msprop:Generator_UserColumnName="GoodsCode" msprop:Generator_ColumnVarNameInTable="columnGoodsCode" msprop:Generator_ColumnPropNameInRow="GoodsCode" msprop:Generator_ColumnPropNameInTable="GoodsCodeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GoodsName" msprop:Generator_UserColumnName="GoodsName" msprop:Generator_ColumnVarNameInTable="columnGoodsName" msprop:Generator_ColumnPropNameInRow="GoodsName" msprop:Generator_ColumnPropNameInTable="GoodsNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Orders" msprop:Generator_UserTableName="Orders" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_TableVarName="tableOrders" msprop:Generator_RowDeletingName="OrdersRowDeleting" msprop:Generator_TablePropName="Orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn" msprop:Generator_ColumnPropNameInRow="DocNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SupplierId" msprop:Generator_UserColumnName="SupplierId" msprop:Generator_ColumnPropNameInRow="SupplierId" msprop:Generator_ColumnVarNameInTable="columnSupplierId" msprop:Generator_ColumnPropNameInTable="SupplierIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SupplierName" msprop:Generator_UserColumnName="SupplierName" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="SupplierName" msprop:Generator_ColumnPropNameInTable="SupplierNameColumn" msprop:Generator_ColumnVarNameInTable="columnSupplierName" type="xs:string" minOccurs="0" />
              <xs:element name="SupplierDocDate" msprop:Generator_UserColumnName="SupplierDocDate" msprop:Generator_ColumnPropNameInRow="SupplierDocDate" msprop:Generator_ColumnVarNameInTable="columnSupplierDocDate" msprop:Generator_ColumnPropNameInTable="SupplierDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SupplierDocNumber" msprop:Generator_UserColumnName="SupplierDocNumber" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="SupplierDocNumber" msprop:Generator_ColumnPropNameInTable="SupplierDocNumberColumn" msprop:Generator_ColumnVarNameInTable="columnSupplierDocNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lines" msprop:Generator_UserColumnName="Lines" msprop:Generator_ColumnPropNameInRow="Lines" msprop:Generator_ColumnVarNameInTable="columnLines" msprop:Generator_ColumnPropNameInTable="LinesColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="DocSum" msprop:Generator_UserColumnName="DocSum" msprop:Generator_ColumnPropNameInRow="DocSum" msprop:Generator_ColumnVarNameInTable="columnDocSum" msprop:Generator_ColumnPropNameInTable="DocSumColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnVarNameInTable="columnNote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn" msprop:Generator_ColumnVarNameInTable="columnMW" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="t_MD" msprop:Generator_UserColumnName="t_MD" msprop:Generator_ColumnVarNameInTable="columnt_MD" msprop:Generator_ColumnPropNameInRow="t_MD" msprop:Generator_ColumnPropNameInTable="t_MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="t_MW" msprop:Generator_UserColumnName="t_MW" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="t_MW" msprop:Generator_ColumnPropNameInTable="t_MWColumn" msprop:Generator_ColumnVarNameInTable="columnt_MW" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="t_Id" msprop:Generator_UserColumnName="t_Id" msprop:Generator_ColumnVarNameInTable="columnt_Id" msprop:Generator_ColumnPropNameInRow="t_Id" msprop:Generator_ColumnPropNameInTable="t_IdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrderM" msprop:Generator_UserTableName="OrderM" msprop:Generator_RowDeletedName="OrderMRowDeleted" msprop:Generator_RowChangedName="OrderMRowChanged" msprop:Generator_RowClassName="OrderMRow" msprop:Generator_RowChangingName="OrderMRowChanging" msprop:Generator_RowEvArgName="OrderMRowChangeEvent" msprop:Generator_RowEvHandlerName="OrderMRowChangeEventHandler" msprop:Generator_TableClassName="OrderMDataTable" msprop:Generator_TableVarName="tableOrderM" msprop:Generator_RowDeletingName="OrderMRowDeleting" msprop:Generator_TablePropName="OrderM">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FullName" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPack" msprop:Generator_UserColumnName="RetailPack" msprop:Generator_ColumnPropNameInRow="RetailPack" msprop:Generator_ColumnVarNameInTable="columnRetailPack" msprop:Generator_ColumnPropNameInTable="RetailPackColumn" type="xs:int" />
              <xs:element name="RestQntty" msdata:ReadOnly="true" msprop:Generator_UserColumnName="RestQntty" msprop:Generator_ColumnPropNameInRow="RestQntty" msprop:Generator_ColumnVarNameInTable="columnRestQntty" msprop:Generator_ColumnPropNameInTable="RestQnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrderQntty" msprop:Generator_UserColumnName="OrderQntty" msprop:Generator_ColumnPropNameInRow="OrderQntty" msprop:Generator_ColumnVarNameInTable="columnOrderQntty" msprop:Generator_ColumnPropNameInTable="OrderQnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrderSum" msprop:Generator_UserColumnName="OrderSum" msprop:Generator_ColumnPropNameInRow="OrderSum" msprop:Generator_ColumnVarNameInTable="columnOrderSum" msprop:Generator_ColumnPropNameInTable="OrderSumColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrderS" msprop:Generator_UserTableName="OrderS" msprop:Generator_RowDeletedName="OrderSRowDeleted" msprop:Generator_RowChangedName="OrderSRowChanged" msprop:Generator_RowClassName="OrderSRow" msprop:Generator_RowChangingName="OrderSRowChanging" msprop:Generator_RowEvArgName="OrderSRowChangeEvent" msprop:Generator_RowEvHandlerName="OrderSRowChangeEventHandler" msprop:Generator_TableClassName="OrderSDataTable" msprop:Generator_TableVarName="tableOrderS" msprop:Generator_RowDeletingName="OrderSRowDeleting" msprop:Generator_TablePropName="OrderS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DocId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
              <xs:element name="SupplierId" msprop:Generator_UserColumnName="SupplierId" msprop:Generator_ColumnPropNameInRow="SupplierId" msprop:Generator_ColumnVarNameInTable="columnSupplierId" msprop:Generator_ColumnPropNameInTable="SupplierIdColumn" type="xs:int" />
              <xs:element name="SupplierName" msprop:Generator_UserColumnName="SupplierName" msprop:Generator_ColumnPropNameInRow="SupplierName" msprop:Generator_ColumnVarNameInTable="columnSupplierName" msprop:Generator_ColumnPropNameInTable="SupplierNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BatchNumber" msprop:Generator_UserColumnName="BatchNumber" msprop:Generator_ColumnPropNameInRow="BatchNumber" msprop:Generator_ColumnVarNameInTable="columnBatchNumber" msprop:Generator_ColumnPropNameInTable="BatchNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReadyBefore" msprop:Generator_UserColumnName="ReadyBefore" msprop:Generator_ColumnPropNameInRow="ReadyBefore" msprop:Generator_ColumnVarNameInTable="columnReadyBefore" msprop:Generator_ColumnPropNameInTable="ReadyBeforeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ReestrPrice" msprop:Generator_UserColumnName="ReestrPrice" msprop:Generator_ColumnPropNameInRow="ReestrPrice" msprop:Generator_ColumnVarNameInTable="columnReestrPrice" msprop:Generator_ColumnPropNameInTable="ReestrPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReestrDate" msprop:Generator_UserColumnName="ReestrDate" msprop:Generator_ColumnPropNameInRow="ReestrDate" msprop:Generator_ColumnVarNameInTable="columnReestrDate" msprop:Generator_ColumnPropNameInTable="ReestrDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NDSTax" msprop:Generator_UserColumnName="NDSTax" msprop:Generator_ColumnPropNameInRow="NDSTax" msprop:Generator_ColumnVarNameInTable="columnNDSTax" msprop:Generator_ColumnPropNameInTable="NDSTaxColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:decimal" />
              <xs:element name="Qntty" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" />
              <xs:element name="OrderQntty" msprop:Generator_UserColumnName="OrderQntty" msprop:Generator_ColumnPropNameInRow="OrderQntty" msprop:Generator_ColumnVarNameInTable="columnOrderQntty" msprop:Generator_ColumnPropNameInTable="OrderQnttyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrderSum" msprop:Generator_UserColumnName="OrderSum" msprop:Generator_ColumnPropNameInRow="OrderSum" msprop:Generator_ColumnVarNameInTable="columnOrderSum" msprop:Generator_ColumnPropNameInTable="OrderSumColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Parties" msprop:Generator_UserTableName="Parties" msprop:Generator_RowDeletedName="PartiesRowDeleted" msprop:Generator_RowChangedName="PartiesRowChanged" msprop:Generator_RowClassName="PartiesRow" msprop:Generator_RowChangingName="PartiesRowChanging" msprop:Generator_RowEvArgName="PartiesRowChangeEvent" msprop:Generator_RowEvHandlerName="PartiesRowChangeEventHandler" msprop:Generator_TableClassName="PartiesDataTable" msprop:Generator_TableVarName="tableParties" msprop:Generator_RowDeletingName="PartiesRowDeleting" msprop:Generator_TablePropName="Parties">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RestQntty" msprop:Generator_UserColumnName="RestQntty" msprop:Generator_ColumnPropNameInRow="RestQntty" msprop:Generator_ColumnVarNameInTable="columnRestQntty" msprop:Generator_ColumnPropNameInTable="RestQnttyColumn" type="xs:int" />
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" />
              <xs:element name="Blocked" msprop:Generator_UserColumnName="Blocked" msprop:Generator_ColumnPropNameInRow="Blocked" msprop:Generator_ColumnVarNameInTable="columnBlocked" msprop:Generator_ColumnPropNameInTable="BlockedColumn" type="xs:boolean" />
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OriginalMD" msprop:Generator_UserColumnName="OriginalMD" msprop:Generator_ColumnPropNameInRow="OriginalMD" msprop:Generator_ColumnVarNameInTable="columnOriginalMD" msprop:Generator_ColumnPropNameInTable="OriginalMDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Original_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Original_id" msprop:Generator_ColumnPropNameInRow="Original_id" msprop:Generator_ColumnVarNameInTable="columnOriginal_id" msprop:Generator_ColumnPropNameInTable="Original_idColumn" type="xs:int" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="GoodsId" msprop:Generator_UserColumnName="GoodsId" msprop:Generator_ColumnVarNameInTable="columnGoodsId" msprop:Generator_ColumnPropNameInRow="GoodsId" msprop:Generator_ColumnPropNameInTable="GoodsIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DocNoParty" msprop:Generator_UserTableName="DocNoParty" msprop:Generator_RowDeletedName="DocNoPartyRowDeleted" msprop:Generator_RowChangedName="DocNoPartyRowChanged" msprop:Generator_RowClassName="DocNoPartyRow" msprop:Generator_RowChangingName="DocNoPartyRowChanging" msprop:Generator_RowEvArgName="DocNoPartyRowChangeEvent" msprop:Generator_RowEvHandlerName="DocNoPartyRowChangeEventHandler" msprop:Generator_TableClassName="DocNoPartyDataTable" msprop:Generator_TableVarName="tableDocNoParty" msprop:Generator_RowDeletingName="DocNoPartyRowDeleting" msprop:Generator_TablePropName="DocNoParty">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DocWithParty" msprop:Generator_UserTableName="DocWithParty" msprop:Generator_RowDeletedName="DocWithPartyRowDeleted" msprop:Generator_RowChangedName="DocWithPartyRowChanged" msprop:Generator_RowClassName="DocWithPartyRow" msprop:Generator_RowChangingName="DocWithPartyRowChanging" msprop:Generator_RowEvArgName="DocWithPartyRowChangeEvent" msprop:Generator_RowEvHandlerName="DocWithPartyRowChangeEventHandler" msprop:Generator_TableClassName="DocWithPartyDataTable" msprop:Generator_TableVarName="tableDocWithParty" msprop:Generator_RowDeletingName="DocWithPartyRowDeleting" msprop:Generator_TablePropName="DocWithParty">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Nblocked" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Nblocked" msprop:Generator_ColumnPropNameInRow="Nblocked" msprop:Generator_ColumnVarNameInTable="columnNblocked" msprop:Generator_ColumnPropNameInTable="NblockedColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ManufacturerAndCountry" msprop:Generator_UserTableName="ManufacturerAndCountry" msprop:Generator_RowDeletedName="ManufacturerAndCountryRowDeleted" msprop:Generator_RowChangedName="ManufacturerAndCountryRowChanged" msprop:Generator_RowClassName="ManufacturerAndCountryRow" msprop:Generator_RowChangingName="ManufacturerAndCountryRowChanging" msprop:Generator_RowEvArgName="ManufacturerAndCountryRowChangeEvent" msprop:Generator_RowEvHandlerName="ManufacturerAndCountryRowChangeEventHandler" msprop:Generator_TableClassName="ManufacturerAndCountryDataTable" msprop:Generator_TableVarName="tableManufacturerAndCountry" msprop:Generator_RowDeletingName="ManufacturerAndCountryRowDeleting" msprop:Generator_TablePropName="ManufacturerAndCountry">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NKLDInfo" msprop:Generator_UserTableName="NKLDInfo" msprop:Generator_RowDeletedName="NKLDInfoRowDeleted" msprop:Generator_RowChangedName="NKLDInfoRowChanged" msprop:Generator_RowClassName="NKLDInfoRow" msprop:Generator_RowChangingName="NKLDInfoRowChanging" msprop:Generator_RowEvArgName="NKLDInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="NKLDInfoRowChangeEventHandler" msprop:Generator_TableClassName="NKLDInfoDataTable" msprop:Generator_TableVarName="tableNKLDInfo" msprop:Generator_RowDeletingName="NKLDInfoRowDeleting" msprop:Generator_TablePropName="NKLDInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContragentDocDate" msprop:Generator_UserColumnName="ContragentDocDate" msprop:Generator_ColumnVarNameInTable="columnContragentDocDate" msprop:Generator_ColumnPropNameInRow="ContragentDocDate" msprop:Generator_ColumnPropNameInTable="ContragentDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SupplierReturnParties" msprop:Generator_UserTableName="SupplierReturnParties" msprop:Generator_RowDeletedName="SupplierReturnPartiesRowDeleted" msprop:Generator_RowChangedName="SupplierReturnPartiesRowChanged" msprop:Generator_RowClassName="SupplierReturnPartiesRow" msprop:Generator_RowChangingName="SupplierReturnPartiesRowChanging" msprop:Generator_RowEvArgName="SupplierReturnPartiesRowChangeEvent" msprop:Generator_RowEvHandlerName="SupplierReturnPartiesRowChangeEventHandler" msprop:Generator_TableClassName="SupplierReturnPartiesDataTable" msprop:Generator_TableVarName="tableSupplierReturnParties" msprop:Generator_RowDeletingName="SupplierReturnPartiesRowDeleting" msprop:Generator_TablePropName="SupplierReturnParties">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="DocDate" msprop:Generator_UserColumnName="DocDate" msprop:Generator_ColumnVarNameInTable="columnDocDate" msprop:Generator_ColumnPropNameInRow="DocDate" msprop:Generator_ColumnPropNameInTable="DocDateColumn" type="xs:dateTime" />
              <xs:element name="DocNumber" msprop:Generator_UserColumnName="DocNumber" msprop:Generator_ColumnVarNameInTable="columnDocNumber" msprop:Generator_ColumnPropNameInRow="DocNumber" msprop:Generator_ColumnPropNameInTable="DocNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContragentDocDate" msprop:Generator_UserColumnName="ContragentDocDate" msprop:Generator_ColumnVarNameInTable="columnContragentDocDate" msprop:Generator_ColumnPropNameInRow="ContragentDocDate" msprop:Generator_ColumnPropNameInTable="ContragentDocDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContragentDocNumber" msprop:Generator_UserColumnName="ContragentDocNumber" msprop:Generator_ColumnVarNameInTable="columnContragentDocNumber" msprop:Generator_ColumnPropNameInRow="ContragentDocNumber" msprop:Generator_ColumnPropNameInTable="ContragentDocNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerId" msprop:Generator_UserColumnName="ManufacturerId" msprop:Generator_ColumnVarNameInTable="columnManufacturerId" msprop:Generator_ColumnPropNameInRow="ManufacturerId" msprop:Generator_ColumnPropNameInTable="ManufacturerIdColumn" type="xs:int" />
              <xs:element name="ManufacturerName" msprop:Generator_UserColumnName="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RetailPrice" msprop:Generator_UserColumnName="RetailPrice" msprop:Generator_ColumnVarNameInTable="columnRetailPrice" msprop:Generator_ColumnPropNameInRow="RetailPrice" msprop:Generator_ColumnPropNameInTable="RetailPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Qntty" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Qntty" msprop:Generator_ColumnVarNameInTable="columnQntty" msprop:Generator_ColumnPropNameInRow="Qntty" msprop:Generator_ColumnPropNameInTable="QnttyColumn" type="xs:int" />
              <xs:element name="Barcode" msprop:Generator_UserColumnName="Barcode" msprop:Generator_ColumnVarNameInTable="columnBarcode" msprop:Generator_ColumnPropNameInRow="Barcode" msprop:Generator_ColumnPropNameInTable="BarcodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expiration" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Expiration" msprop:Generator_ColumnVarNameInTable="columnExpiration" msprop:Generator_ColumnPropNameInRow="Expiration" msprop:Generator_ColumnPropNameInTable="ExpirationColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="SupplierDocId" msprop:Generator_UserColumnName="SupplierDocId" msprop:Generator_ColumnVarNameInTable="columnSupplierDocId" msprop:Generator_ColumnPropNameInRow="SupplierDocId" msprop:Generator_ColumnPropNameInTable="SupplierDocIdColumn" type="xs:int" />
              <xs:element name="AllowUnPack" msprop:Generator_UserColumnName="AllowUnPack" msprop:Generator_ColumnVarNameInTable="columnAllowUnPack" msprop:Generator_ColumnPropNameInRow="AllowUnPack" msprop:Generator_ColumnPropNameInTable="AllowUnPackColumn" type="xs:boolean" />
              <xs:element name="RetailPack" msprop:Generator_UserColumnName="RetailPack" msprop:Generator_ColumnVarNameInTable="columnRetailPack" msprop:Generator_ColumnPropNameInRow="RetailPack" msprop:Generator_ColumnPropNameInTable="RetailPackColumn" type="xs:int" />
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CIA" msprop:Generator_UserTableName="CIA" msprop:Generator_RowDeletedName="CIARowDeleted" msprop:Generator_RowChangedName="CIARowChanged" msprop:Generator_RowClassName="CIARow" msprop:Generator_RowChangingName="CIARowChanging" msprop:Generator_RowEvArgName="CIARowChangeEvent" msprop:Generator_RowEvHandlerName="CIARowChangeEventHandler" msprop:Generator_TableClassName="CIADataTable" msprop:Generator_TableVarName="tableCIA" msprop:Generator_RowDeletingName="CIARowDeleting" msprop:Generator_TablePropName="CIA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CODE" msprop:Generator_UserColumnName="CODE" msprop:Generator_ColumnPropNameInRow="CODE" msprop:Generator_ColumnVarNameInTable="columnCODE" msprop:Generator_ColumnPropNameInTable="CODEColumn" type="xs:double" />
              <xs:element name="KOLVO" msprop:Generator_UserColumnName="KOLVO" msprop:Generator_ColumnPropNameInRow="KOLVO" msprop:Generator_ColumnVarNameInTable="columnKOLVO" msprop:Generator_ColumnPropNameInTable="KOLVOColumn" type="xs:double" />
              <xs:element name="PRICE_OPL" msprop:Generator_UserColumnName="PRICE_OPL" msprop:Generator_ColumnPropNameInRow="PRICE_OPL" msprop:Generator_ColumnVarNameInTable="columnPRICE_OPL" msprop:Generator_ColumnPropNameInTable="PRICE_OPLColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SUM_BASE" msprop:Generator_UserColumnName="SUM_BASE" msprop:Generator_ColumnPropNameInRow="SUM_BASE" msprop:Generator_ColumnVarNameInTable="columnSUM_BASE" msprop:Generator_ColumnPropNameInTable="SUM_BASEColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NDS_PR" msprop:Generator_UserColumnName="NDS_PR" msprop:Generator_ColumnPropNameInRow="NDS_PR" msprop:Generator_ColumnVarNameInTable="columnNDS_PR" msprop:Generator_ColumnPropNameInTable="NDS_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NDS_SUM" msprop:Generator_UserColumnName="NDS_SUM" msprop:Generator_ColumnPropNameInRow="NDS_SUM" msprop:Generator_ColumnVarNameInTable="columnNDS_SUM" msprop:Generator_ColumnPropNameInTable="NDS_SUMColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SUM_OPL" msprop:Generator_UserColumnName="SUM_OPL" msprop:Generator_ColumnPropNameInRow="SUM_OPL" msprop:Generator_ColumnVarNameInTable="columnSUM_OPL" msprop:Generator_ColumnPropNameInTable="SUM_OPLColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NSP" msprop:Generator_UserColumnName="NSP" msprop:Generator_ColumnPropNameInRow="NSP" msprop:Generator_ColumnVarNameInTable="columnNSP" msprop:Generator_ColumnPropNameInTable="NSPColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRICE_BASE" msprop:Generator_UserColumnName="PRICE_BASE" msprop:Generator_ColumnPropNameInRow="PRICE_BASE" msprop:Generator_ColumnVarNameInTable="columnPRICE_BASE" msprop:Generator_ColumnPropNameInTable="PRICE_BASEColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRO" msprop:Generator_UserColumnName="PRO" msprop:Generator_ColumnPropNameInRow="PRO" msprop:Generator_ColumnVarNameInTable="columnPRO" msprop:Generator_ColumnPropNameInTable="PROColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRO_NNDS" msprop:Generator_UserColumnName="PRO_NNDS" msprop:Generator_ColumnPropNameInRow="PRO_NNDS" msprop:Generator_ColumnVarNameInTable="columnPRO_NNDS" msprop:Generator_ColumnPropNameInTable="PRO_NNDSColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRO_PR" msprop:Generator_UserColumnName="PRO_PR" msprop:Generator_ColumnPropNameInRow="PRO_PR" msprop:Generator_ColumnVarNameInTable="columnPRO_PR" msprop:Generator_ColumnPropNameInTable="PRO_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NC_IMP_PR" msprop:Generator_UserColumnName="NC_IMP_PR" msprop:Generator_ColumnPropNameInRow="NC_IMP_PR" msprop:Generator_ColumnVarNameInTable="columnNC_IMP_PR" msprop:Generator_ColumnPropNameInTable="NC_IMP_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NC_IMP_SUM" msprop:Generator_UserColumnName="NC_IMP_SUM" msprop:Generator_ColumnPropNameInRow="NC_IMP_SUM" msprop:Generator_ColumnVarNameInTable="columnNC_IMP_SUM" msprop:Generator_ColumnPropNameInTable="NC_IMP_SUMColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NC_OPT_PR" msprop:Generator_UserColumnName="NC_OPT_PR" msprop:Generator_ColumnPropNameInRow="NC_OPT_PR" msprop:Generator_ColumnVarNameInTable="columnNC_OPT_PR" msprop:Generator_ColumnPropNameInTable="NC_OPT_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NC_OPT_SUM" msprop:Generator_UserColumnName="NC_OPT_SUM" msprop:Generator_ColumnPropNameInRow="NC_OPT_SUM" msprop:Generator_ColumnVarNameInTable="columnNC_OPT_SUM" msprop:Generator_ColumnPropNameInTable="NC_OPT_SUMColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRICE_OPT" msprop:Generator_UserColumnName="PRICE_OPT" msprop:Generator_ColumnPropNameInRow="PRICE_OPT" msprop:Generator_ColumnVarNameInTable="columnPRICE_OPT" msprop:Generator_ColumnPropNameInTable="PRICE_OPTColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRICE_REES" msprop:Generator_UserColumnName="PRICE_REES" msprop:Generator_ColumnPropNameInRow="PRICE_REES" msprop:Generator_ColumnVarNameInTable="columnPRICE_REES" msprop:Generator_ColumnPropNameInTable="PRICE_REESColumn" type="xs:double" minOccurs="0" />
              <xs:element name="DATE_REES" msprop:Generator_UserColumnName="DATE_REES" msprop:Generator_ColumnPropNameInRow="DATE_REES" msprop:Generator_ColumnVarNameInTable="columnDATE_REES" msprop:Generator_ColumnPropNameInTable="DATE_REESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SERIES" msprop:Generator_UserColumnName="SERIES" msprop:Generator_ColumnPropNameInRow="SERIES" msprop:Generator_ColumnVarNameInTable="columnSERIES" msprop:Generator_ColumnPropNameInTable="SERIESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WEIGHT" msprop:Generator_UserColumnName="WEIGHT" msprop:Generator_ColumnPropNameInRow="WEIGHT" msprop:Generator_ColumnVarNameInTable="columnWEIGHT" msprop:Generator_ColumnPropNameInTable="WEIGHTColumn" type="xs:double" minOccurs="0" />
              <xs:element name="DCODE" msprop:Generator_UserColumnName="DCODE" msprop:Generator_ColumnPropNameInRow="DCODE" msprop:Generator_ColumnVarNameInTable="columnDCODE" msprop:Generator_ColumnPropNameInTable="DCODEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATE_DOC" msprop:Generator_UserColumnName="DATE_DOC" msprop:Generator_ColumnPropNameInRow="DATE_DOC" msprop:Generator_ColumnVarNameInTable="columnDATE_DOC" msprop:Generator_ColumnPropNameInTable="DATE_DOCColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GTD" msprop:Generator_UserColumnName="GTD" msprop:Generator_ColumnPropNameInRow="GTD" msprop:Generator_ColumnVarNameInTable="columnGTD" msprop:Generator_ColumnPropNameInTable="GTDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SERT_N" msprop:Generator_UserColumnName="SERT_N" msprop:Generator_ColumnPropNameInRow="SERT_N" msprop:Generator_ColumnVarNameInTable="columnSERT_N" msprop:Generator_ColumnPropNameInTable="SERT_NColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_APTEKA" msprop:Generator_UserColumnName="ID_APTEKA" msprop:Generator_ColumnPropNameInRow="ID_APTEKA" msprop:Generator_ColumnVarNameInTable="columnID_APTEKA" msprop:Generator_ColumnPropNameInTable="ID_APTEKAColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ID_FILIAL" msprop:Generator_UserColumnName="ID_FILIAL" msprop:Generator_ColumnPropNameInRow="ID_FILIAL" msprop:Generator_ColumnVarNameInTable="columnID_FILIAL" msprop:Generator_ColumnPropNameInTable="ID_FILIALColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRICE_O" msprop:Generator_UserColumnName="PRICE_O" msprop:Generator_ColumnPropNameInRow="PRICE_O" msprop:Generator_ColumnVarNameInTable="columnPRICE_O" msprop:Generator_ColumnPropNameInTable="PRICE_OColumn" type="xs:double" minOccurs="0" />
              <xs:element name="XCONCEPT" msprop:Generator_UserColumnName="XCONCEPT" msprop:Generator_ColumnPropNameInRow="XCONCEPT" msprop:Generator_ColumnVarNameInTable="columnXCONCEPT" msprop:Generator_ColumnPropNameInTable="XCONCEPTColumn" type="xs:double" minOccurs="0" />
              <xs:element name="TAM_PER" msprop:Generator_UserColumnName="TAM_PER" msprop:Generator_ColumnPropNameInRow="TAM_PER" msprop:Generator_ColumnVarNameInTable="columnTAM_PER" msprop:Generator_ColumnPropNameInTable="TAM_PERColumn" type="xs:double" minOccurs="0" />
              <xs:element name="TAM_SUM" msprop:Generator_UserColumnName="TAM_SUM" msprop:Generator_ColumnPropNameInRow="TAM_SUM" msprop:Generator_ColumnVarNameInTable="columnTAM_SUM" msprop:Generator_ColumnPropNameInTable="TAM_SUMColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PRODUCT" msprop:Generator_UserColumnName="PRODUCT" msprop:Generator_ColumnPropNameInRow="PRODUCT" msprop:Generator_ColumnVarNameInTable="columnPRODUCT" msprop:Generator_ColumnPropNameInTable="PRODUCTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="160" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRODUCER" msprop:Generator_UserColumnName="PRODUCER" msprop:Generator_ColumnPropNameInRow="PRODUCER" msprop:Generator_ColumnVarNameInTable="columnPRODUCER" msprop:Generator_ColumnPropNameInTable="PRODUCERColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="160" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SROK_S" msprop:Generator_UserColumnName="SROK_S" msprop:Generator_ColumnPropNameInRow="SROK_S" msprop:Generator_ColumnVarNameInTable="columnSROK_S" msprop:Generator_ColumnPropNameInTable="SROK_SColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NSP_PR" msprop:Generator_UserColumnName="NSP_PR" msprop:Generator_ColumnPropNameInRow="NSP_PR" msprop:Generator_ColumnVarNameInTable="columnNSP_PR" msprop:Generator_ColumnPropNameInTable="NSP_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="EAN13" msprop:Generator_UserColumnName="EAN13" msprop:Generator_ColumnPropNameInRow="EAN13" msprop:Generator_ColumnVarNameInTable="columnEAN13" msprop:Generator_ColumnPropNameInTable="EAN13Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="26" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FARMCODE" msprop:Generator_UserColumnName="FARMCODE" msprop:Generator_ColumnPropNameInRow="FARMCODE" msprop:Generator_ColumnVarNameInTable="columnFARMCODE" msprop:Generator_ColumnPropNameInTable="FARMCODEColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SE_NUM" msprop:Generator_UserColumnName="SE_NUM" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnSE_NUM" msprop:Generator_ColumnPropNameInTable="SE_NUMColumn" msprop:Generator_ColumnPropNameInRow="SE_NUM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="160" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SE_ORG" msprop:Generator_UserColumnName="SE_ORG" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnSE_ORG" msprop:Generator_ColumnPropNameInTable="SE_ORGColumn" msprop:Generator_ColumnPropNameInRow="SE_ORG" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SE_SROK" msprop:Generator_UserColumnName="SE_SROK" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnSE_SROK" msprop:Generator_ColumnPropNameInTable="SE_SROKColumn" msprop:Generator_ColumnPropNameInRow="SE_SROK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RetailMarkupWeight" msprop:Generator_UserTableName="RetailMarkupWeight" msprop:Generator_RowDeletedName="RetailMarkupWeightRowDeleted" msprop:Generator_RowChangedName="RetailMarkupWeightRowChanged" msprop:Generator_RowClassName="RetailMarkupWeightRow" msprop:Generator_RowChangingName="RetailMarkupWeightRowChanging" msprop:Generator_RowEvArgName="RetailMarkupWeightRowChangeEvent" msprop:Generator_RowEvHandlerName="RetailMarkupWeightRowChangeEventHandler" msprop:Generator_TableClassName="RetailMarkupWeightDataTable" msprop:Generator_TableVarName="tableRetailMarkupWeight" msprop:Generator_RowDeletingName="RetailMarkupWeightRowDeleting" msprop:Generator_TablePropName="RetailMarkupWeight">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RetailMarkup" msprop:Generator_UserColumnName="RetailMarkup" msprop:Generator_ColumnVarNameInTable="columnRetailMarkup" msprop:Generator_ColumnPropNameInRow="RetailMarkup" msprop:Generator_ColumnPropNameInTable="RetailMarkupColumn" type="xs:double" minOccurs="0" />
              <xs:element name="MarkupWeight" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MarkupWeight" msprop:Generator_ColumnVarNameInTable="columnMarkupWeight" msprop:Generator_ColumnPropNameInRow="MarkupWeight" msprop:Generator_ColumnPropNameInTable="MarkupWeightColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SupplierInvoiceDocInsert" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SupplierInvoiceLinesInsert_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SupplierInvoiceLinesInsert" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="CurrentNakl_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CurrentNakl" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="PartiesUpdate_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PartiesUpdate" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SZData_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SZData" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="ContragentsLinks_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ContragentsLinks" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SupplierReturns_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SupplierReturns" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SetificatedOrg_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SetificatedOrg" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SupplierReturnLines_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SupplierReturnLines" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="vwGoodsDetailed_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:vwGoodsDetailed" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="OrderM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrderM" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Parties_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Parties" />
      <xs:field xpath="mstns:Original_id" />
    </xs:unique>
    <xs:unique name="SupplierReturnParties_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SupplierReturnParties" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="OrderM_OrderS" msdata:parent="OrderM" msdata:child="OrderS" msdata:parentkey="Id" msdata:childkey="GoodsId" msprop:Generator_UserRelationName="OrderM_OrderS" msprop:Generator_RelationVarName="relationOrderM_OrderS" msprop:Generator_UserChildTable="OrderS" msprop:Generator_UserParentTable="OrderM" msprop:Generator_ParentPropName="OrderMRow" msprop:Generator_ChildPropName="GetOrderSRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>